st: correction: how to stack some variables and duplicate others

[Mariano Matias Iberico <matias.iberico@gmail.com>]

Sorry, I didn't take into account spaces in plaintext.  Here is a better version.

I am looking at data similar to adherence to 3 month treatment.

I have data on households that have been grouped into two categories by

age 0-15 and 15-18  the dataset looks roughly like this:

houseID num015 m1_15 m2_15 m3_15 num1518 m1_18 m2_18 m3_18 income edu

1       5      4     3     3     4       4     4     0     100     1

2       2      2     2     1     0       0     0     0     110     2

3       0      0     0     0     1       1     1     1     1000    6

. . .

I would like to -stack-num015-m3_18, into(ptnum m1 m2 m3)

When I do this I loose the income and edu data, which I would like to

duplicate as shown below.

houseID ptnum m1 m2 m3 income edu _stack

1       5     4  3  3  100    1   1

1       4     4  4  0  100    1   2

2       2     2  2  1  110    2   1

2       0     0  0  0  110    2   2

3       0     0  0  0  1000   6   1

3       1     1  1  1  1000   6   2

. . .

I tried -reshape– but can't get it to work either.

The next step for this is to -rename- and -label-_stack into an age variable and –expand–ptnum.  Then I have a code written

to change m1-m3 into dummy variables to see how far along each pt of each

age got in the treatment.

Any suggestions are welcome as I have been banging my head against the

wall with this one for some time!

Regards,

Matias