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
Draw a stratified random sampleHi, I am working with a survey where I have information at the individual and household levels. I s…
eclass store resultsDear stata users, I would like to store a matrix and the number of observations after my eclass pro…
unknown function () in a simple generate commandHi, I am trying to generate a new variable b with the following formula using all existing variable…
Reshaping data from wide to longWhen I try to reshape I keep getting this error r(111) no xij variables found You typed something li…
how to write the loop statement?I want to write a loop statement to generate a lot of rowmean? How to write such loop statement? Her…
Subscribe to:
Post Comments (Atom)
0 Response to Delete panel observations which are nonconsecutive data
Post a Comment