I have monthly time-series data for 4435-panel ids. Time series should be for consecutive months. However, for some panels, I find a gap in monthly data. I can find the observations of panels, for which there is a time gap by taking the difference of the current month and lagged current month. I can delete those observations of which difference is null (.) or not 1. But my problem is that, if I delete observation in this way, I lose one observation per panel from which consecutive data starts. I want to keep that observation from which consecutive data starts but I find no way to handle this after exploring all threads.
For example: for FUNDNO = 38, I have missing consecutive observations from June 1989-Dec 1996. But it has consecutive observations from May 1997. How can I drop those non-consecutive observations only for (i.e. from June 1989-Dec 1996) except May 1997 from which consecutive data starts, for each panel?
Array
I appreciate your support. Thank you very much in advance.
Related Posts with Delete panel observations which are nonconsecutive data
Putexcel : looping over many tables produces duplicates where there are missing dataI am using the World Values Survey, which has a repeated cross sectional design. Different countries…
Stata cannot find my variableHi Statalist, I created a new variable, c_chol. Stata can summarize this for me so it does recogniz…
Weighted regression using iweightHello all, For my meta analysis I need to do a regression that is weighted by standard errors (SE). …
Competing risks regression and multiple imputationHello, I am analysing a longitudinal dataset and I would like to analyse the effect of several fact…
Difficulty interpreting Skewness and Kurtosis ResultsI am looking for guidance on interpreting my results from running a rsktest. Below are my results wh…
Subscribe to:
Post Comments (Atom)
0 Response to Delete panel observations which are nonconsecutive data
Post a Comment