st: RE: Converting the values of a variable into variables

["Carlos de Los Rios" <cdelosrios@minag.gob.pe>]

Hi,

Try first encoding the datadefinition variable by:

encode datadefinition, g(name)

Following try reshape:

reshape wide datavalue, i(id) j(name)

afterwards, you may want to rename your variables:

ren datavalue1 income
ren datavalue2 age
ren datavalue3 weight

Hope its useful!

Carlos DLR

-----Mensaje original-----
De: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] En nombre de
sdm1@york.ac.uk
Enviado el: Jueves, 24 de Noviembre de 2005 01:32 p.m.
Para: statalist@hsphsun2.harvard.edu
Asunto: st: Converting the values of a variable into variables

Hi,

I have a data set of the form:

id datadefiniton datavalue
1   income          1000
1   age               64
1   weight           125
2   income          1500
2   age               44
2   weight           165

which I want to convert to the form:

id income age weight 
1   1000    64   125
2   1500    44   165

Any suggestions would be most welcome!

Thanks.

Steve

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/