Hello everyone,
My data set is as following : -
Year - month Production
Jan 2008 .1
Feb 2008 .2
etc
So I write a code which marks out the 5 months with the MAXIMUM
production. That is easy. Next I want to see what happens 3 months
after the original 5 months of max production.
I do the above two as follows: --
sort production
gen marker=_n
replace marker=. if marker>5
replace marker=9 if marker~=.
forvalues x=1/3{
replace marker=1 if marker[_n-`x']==9 & marker~=9
}
( there are many other ways of doing this, I did this because I do not
want cascading of the marker )
So now the original 5 months are marked 9 and the following 3 months
are marked one.
I could drop the unmarker entries and RESHAPE my dataset and I would
have what I want. BUT here is my problem.
there could be OVERLAPPING entries ruining my reshape. Let me explain.
I could have:-
Year-Month Marker
Jan-08 9
Feb-08 1
Mar-08 1
Apr-08 1
May 9
Jun 9
July 1
Aug 1
Sept 1
Has anyone experienced this ? One way where I think I can work around
this is that I SAVE the dataset with marker~=. Then I keep only one
month marker 9 , it's following 3 months, reshape and save and append
all the reshaped lines in the end. IS there a better way of doing this
?
Thank you,
Ashim
*
* 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/