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!