Nick I beg to differ you
I have done using stata programming what I intend to do but then I
thought why to have unnecessarily the data file which I do not want. I
ma definite about reshape and separate would not do good.
Let me try final time to explain what I am interested in doing.
suppose we use this sales1.data and do
use sales1.dta, clear
keep if sate_code==1
ren sate_code sate_code1
ren exp_val exp_val1
ren sales_val sales_val1
save sales1_1.data, replace
.
.
.
use sales1.dta, clear
keep if sate_code==20
ren sate_code sate_code20
ren exp_val exp_val20
ren sales_val sales_val20
save sales1_20.dta, replace
use sales1_1.data, clear
merge common_id using sales1_2.dta
save sales1_1_2.dta
.
.
.
use sales1_1_19.data, clear
merge common_id using sales1_20.dta
save sales1_1_20.dta
But this way I have 40 data file but what I am trying to in the code
posted in first mail is to have only one file finaly i.e.
sales1_1_20.dta
Thanks
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/
