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
Concentration Index (industries within one sector per country)Hello, I have a set of industries within one sector and I would like to calculate the degree of con…
replacing variable value via a loop conditioning on the contents of other variablesHello, I have dataset which has 14 variables relating ethnic group: eth1 eth2 eth3...eth14. The va…
splitting Chinese addresses?Dear All, Suppose that I have the following addresses (in Chinese), Code: * Example generated by -d…
countingHello, I have a database in Stata and I need to count the number of nodules in each patient. The fir…
In Stata 17.0 Kaplan-Meier graph with log scale in xaxis impossible due to start at zero, why?Hi, I have tried to start Kaplan-Meier plot with logscale at time -axis using several forms of stset…
Subscribe to:
Post Comments (Atom)
0 Response to Drop variables in STATA if next year data is missing
Post a Comment