Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Unable to create lag variables in a panel dataset


From   "Jabr, Wael M" <[email protected]>
To   <[email protected]>
Subject   st: Unable to create lag variables in a panel dataset
Date   Fri, 14 Aug 2009 11:38:04 -0500

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.

Any help please?

*
*   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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index