Reshaping/collpasing institution level data

[Marvin85]

I have data for lets say 10 health centers. There are a series of variables that ask for number of clients serve by age group. For example.

var1= provide emergency contraception to 12-14 years old.
var2 = provide emergency contraception to 15-17 years old.
var3= provide emergency contraception to 17-19 years old.

Notice that there are 3 different variables.

var1 var2 var3
center1 23 30 12
center2 34 20 24

is there a way to create a variable or table that combine these tres variables in one. That is:

Newvariable
1=12-14
2= 15-17
3= 18-19

Please This would save me a lot of time.

Thanks in advance.
Marvin

 

[bukharin]

This sounds like a -reshape long-, although we'd need to have a clearer idea of your desired final data structure to be sure

 

[belfagor71]

provide more info as it is not clear what you need to do.

var1= provide emergency contraception to 12-14 years old.
var2 = provide emergency contraception to 15-17 years old.
var3= provide emergency contraception to 17-19 years old.

Notice that there are 3 different variables.

All of the 3 var above are presumably dummies so you can easily generate a unique variable out of them.

It is not clear though what you have to do with:

center1 23 30 12
center2 34 20 24