Hello,
Im working on a dataset and want to expand my dataset backwards for 2 months extra. The dataex I added shows first the GVKEY (company ID), then the date and then the variabele (DLCQ).
For example: if the data is june 2009 I want to add May and April to the date variabele and take over the value of DLCQ in these months (25.353 in this case)
[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 gvkey long date double dlcq
"001004" 14669 25.353
"001004" 14761 26.314
"001004" 14853 48.151
"001004" 14944 50.437
"001004" 15034 49.665
"001004" 15126 13.652
"001004" 15218 65.396
"001004" 15309 71.162
"001004" 15399 20.89
Thank you!
Related Posts with Expanding backwards
GMM on static modelsHi, I was wondering if is it possible to use the GMM (xtabond2) on a static model. I'm aware that th…
How to correct the alignment of outputI am doing data cleaning and the output is hard to clean because of how it is coming out. For some t…
qlqc30 errorCan anyone explain/solve this problem? . qlqc30, filename("mira_feb_2020_kun_baseline.dta") version…
Standard Errors FE IV Regression, Panel DataHello, I am working with StataIC16, and with Panel Data, where i=550 and t=6. To determine the effe…
cmp multivariate probitHi, I am running a multivariate probit model using the cmp function on 4 binary dependent variables…
Subscribe to:
Post Comments (Atom)
0 Response to Expanding backwards
Post a Comment