NIck,
The data set has state code which range from 1 to 20 and each of these
signifies a separate variable and there are 36 file ( total number of
states).
If I simply use keep if command and create 20 data file for each state
and then merge then have single state level data it will consume lot
of space in my computer, so I thought of creating these 20 data file
some kind of tempfile which will not be in system once I merge the
data.
I do not think that reshape and separate will do good here as each
state_code is for some different variable.
In essence I am trying to use save multiple time but really not
interested to have that data in my system one final merging is done.
Prakash
*
* 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/