Good day,
I am working on my thesis, and I have separate variables from OECD on excel sheets. Individually, the variables are already in a panel format. The problem is that sheets only show data from the years available even though I have a filter from 1985 until 2019 (i.e. I have GDP growth from 1985 until 2019 for a certain country, but the same country's interest rates data is only from 1990 until 2019). I find that severely problematic because I do not know how to prepare a database due to mismatches if I want to put all sheets in one. I was wondering if there are any commands in Stata with which I can circumvent this problem?
I attached an image of the excel sheets combined to visualize my difficulty.
Array
Related Posts with Creating a Panal Data Sheet in excel for STATA
Panel data - Creating a date variable from year and weeknumber as stringStata listers I am writing with a query relating to panel data for historical prices. I am trying t…
Margins: trouble with continuous interactions under simultaneous fixed effectsSometimes I wish to control for variable X via fixed effects (say, year fixed effects) but also allo…
Please help: Importing and merging multiple sheets from an excel file while renaming variables using loopsHello, I am quite new using loops and really want to understand it better. I have an excel file with…
Panel data regressionHello everyone, I'm writing my thesis and I'm struggling with the processing of my data. First of a…
Time varying covariate in Cox Regression modelHi all. After a thorough search online I can't seem to find a solution to my problem, which is why I…
Subscribe to:
Post Comments (Atom)
0 Response to Creating a Panal Data Sheet in excel for STATA
Post a Comment