Hello, I need some help
I have large unbalance panel data and I need to drop the Person ID (PID) if its next year data is missing. See the sample:
PID Year Explanatory variable
1 2009 12
1 2010 12
1 2011 7
1 2012 8
1 2013 14
2 2009 12
3 2009 45
3 2010 56
3 2011 34
3 2012 23
4 2009 212
5 2009 12
5 2010 34
So at time 1 which is 2009, I am considering data of Persons then its impact will be on the Dependent Variable next year data time 2. So, if PID is missing in next year these observations are useless for me. Example PID: 2 and 4 above. How I can drop them I cannot do it manually its huge data base.
Related Posts with Drop variables in STATA if next year data is missing
Problems with local macros in finding an excel fileHello Statalisters, I've being working all day in a code and i couldn't make it work. Because i'm re…
Randomly Assigning TreatmentI have person-year level data, and I am utilizing DiD that exploits state-level shocks. Each person …
Calculating residuals in a multinomial regression as part of 2SRII am attempting to do a 2 stage residual inclusion (2SRI) model where the first stage is estimating …
Double fixed effects Yes/No with estoutI need to declare two fixed effects at bottom of regression table, but second fixed effect (Time FE)…
create a matrixHi all, This might be a trivial question but whatever I have tried seems not working. (e.g. looping…
Subscribe to:
Post Comments (Atom)
0 Response to Drop variables in STATA if next year data is missing
Post a Comment