|
From | Philipp Rehm <Philipp.Rehm@gmx.de> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: RE: RE: Problem with "reshape" |
Date | Wed, 04 Oct 2006 18:08:02 +0200 |
Thanks Justin, but 'stack' doesn't work because I need to preserve the
individuals' code.
Juanita
-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of White, Justin
Sent: Wednesday, October 04, 2006 11:47 AM
To: statalist@hsphsun2.harvard.edu
Subject: st: RE: Problem with "reshape"
Try the 'stack' command
Justin White
-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Riano,
Juanita
Sent: Wednesday, October 04, 2006 11:43 AM
To: statalist@hsphsun2.harvard.edu
Subject: st: Problem with "reshape"
Dear all,
I have a wide dataset organized as follows
date code1_varx code1_vary code2_varx code2_vary
1990 10 20 10 30
1991 10 20 10 30
...
Where: code1- code300 identify individuals and varx vary are the
varnames (I have 9 variables).
What I want is a long dataset that looks like this
date code varx vary
1990 1 10 20
1991 1 10 20
..
1990 2 10 30
1991 2 10 30
..
Using the reshape command hasn't worked for me so far because the stub
that identifies the name of the variable is at the end of it: no xij variables found r(111);
I also tried to transpose the data using the "xpose" command to
manipulate the names but when you use "xpose" twice the string variables
are dropped,,,
I would really appreciate any suggestion on how to proceed,,,
Thank you very much,
Juanita Riano
*
* 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/
*
* 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/
© Copyright 1996–2025 StataCorp LLC | Terms of use | Privacy | Contact us | What's new | Site index |