In addition to other suggestions, did you
tsset userid month, monthly
???
Nick
[email protected]
Jabr, Wael M
I have a large unbalanced panel dataset that I collected. The panel
variable is the userid (~30,000 users) and the time variable is the
month (22 months). Both userid and month are numeric variables. All
users do not have observations for each of the 22 months as some join
later in the study. My dataset is in .dta format.
I am trying to define lag variables but keep failing.
I tried:
sort userid month
tsset userid month
and alterbatively
xtset userid month
Then whenever I try to define a lag variable for the var totsol
gen l1totsol = l1.totsol
(100080 missing values generated)
I thought there might be something wrong in my dataset and tried to use
webuse abdata
sort id year
tsset id year
(or xtset id year)
Then whenever I try to generate the lag variable for the var n, I get
missing values generated.
gen l1n= l1.n
(140 missing values generated)
I also tried 2 other approaches with no avail
. by id: gen lag1=wage[_n-1]
(140 missing values generated)
. by id: gen lag1 = wage[_n-1] if year==year[_n-1]+1
(140 missing values generated)
This kept me up all day and all night yesterday.
*
* 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/
