st: RE: RE: Problem with reshaping dataset

[Amal Khanolkar <Amal.Khanolkar@ki.se>]

Thanks - I didn't follow the help file on reshape in regards to stubnames.

If I want to change the dataset from wide to long, I should provide 'stubs of variable names'. Does this mean the stub of time variable, in this case 'year'.  And I specify a new variable variable for 'j'??

year is coded as year_1   year_2  year_3 and so on.


reshape long year, i(lopnr) j(time)


Thanks,

/Amal.


________________________________________
From: owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu] on behalf of Nick Cox [n.j.cox@durham.ac.uk]
Sent: 07 June 2012 13:54
To: 'statalist@hsphsun2.harvard.edu'
Subject: st: RE: Problem with reshaping dataset

Short answer is almost certainly Yes. You didn't specify any stubnames. So, you are confusing the syntax for an initial -reshape- and that for reversing a -reshape-.

Nick
n.j.cox@durham.ac.uk

Amal Khanolkar

I'm trying to reshape a dataset from wide to long format.

The id variable is called 'lopnr'

And time is specified in years (1980 to 2000) and is called 'year'

I tried the following:

reshape long, i(lopnr) j(year)

This above doesn't work. The error I get is: 'year contains all missing values'.

Do I need to specify any other varibales after long in the command line??

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/