Hello there, I have a panel with variables fundno, fdate, stock_id, stock_price and holdings. Many of fundno - stock_price pairs are observed twice a year( second and fourth quarter) before 2004 and I want to impute first and third quarterly obs. before 2004 by carrying forward the previous fdate's holding for each fundno - stock_id pair. I tried to use "fillin fundno stock_id fdate" to get a balanced panel and then delete consecutive missing obs. (>=2) for each fundno - stock_id pair and then use carryforward, but the balanced data got so huge that my laptop couldn't handle. Plus I couldn't find a good way to delete consecutive missing obs.(tried tsspell but it didn't work) Is there any better way to this?
Thanks,
Hank
Related Posts with How to impute quarterly panel data based on semiannual panel data by copying previous obs.?
Loop foreach helpHi everyone. I am trying to fill in missing values in one variable by completing it with values from…
Stacked Bar GraphHello, I am in need of some assistance. I am trying to create a stacked bar graph to observe the ex…
Panel Data Estimation of Driscoll–Kraay standard errors with plug-in estimators (Optimum number of lags)Dear Experts and Researchers, Would you please suggest on how to estimate Driscoll–Kraay standard er…
Why does Stata graph box not ignore missing values _hi Stata Gurus, I am trying to check the outliners in my data. For example, the total asset (ta) of …
Counting Upwind and Nonupwind firesHi, I have data on the cluster locations. with lat & log information and data on the fire locati…
Subscribe to:
Post Comments (Atom)
0 Response to How to impute quarterly panel data based on semiannual panel data by copying previous obs.?
Post a Comment