Hi,
I'm quite new to Stata so I am in a bit of a pickle. I need to get a long format firm-year panel done. I have all the raw data in excel sheets and this is the description of my excel sheets:
- 10 Excel Files
- Each File has multiple worksheets: AU, BG, CN, IN, etc
- Each region has 2 worksheets, one for each variable
- 2 variables in question: UP and NOSH
- Each excel file corresponds to a year and each of the AU_UP, AU_NOSH, BG_UP, BG_NOSH sheets have monthly data, so the column names are end of month dates (ex: 12/31/2010)
I am lost as to how to create a long format firm-year panel for these because the data is across multiple excel files and across multiple sheets. So each excel file has AU_UP and AU_NOSH monthly data for example, only for that particular year. I do not understand how I can cycle through these files and basically have stata append the 2011 AU_UP data to the end of the 2010 AU_UP data in another file and so on. Any sort of help would be amazing, thank you so much.
Related Posts with Reshape to Long-Firm Year Panel - Data in Multiple excel files and multiple worksheets
Interaction terms giving error "factor variables may not contain noninteger values"Hi, I have data of rainfall for each state and year, and I am explaining it based on the size of th…
LoopHello Stata-Community, I have a varlist called 'surgery' containing numbers from 1-5. I would like …
Interpreting multilevel mixed-effects linear regressionHi, I am doing medical research and I am currently facing some challenges. I have received help fr…
Rolling Window Regression CAPMHello Together I would like to do a rolling window regression (i.e. explain the returns of the funds…
Margins of an interaction after xtlogit, reDear all, I run into an apparently (at least, for me) strange result. I have a longitudinal (even if…
Subscribe to:
Post Comments (Atom)
0 Response to Reshape to Long-Firm Year Panel - Data in Multiple excel files and multiple worksheets
Post a Comment