Hi
I am trying to construct a panel dataset comprised of yearly observations of import values for different countries. Also included other basic variables like GDP, employment etc.
All of the variables are measured at the country-year level, so there is one observation for country x in each year.
However, the import values are refined to different product codes (HS codes) in order to differentiate between different products which have been imported. The issue with this is that there are thousands of different HS codes, so the data isn't balanced. It basically shows different import values for different HS codes, at country x in year y. All of the other variables (GDP, Employment etc.) are just repeated for each observation of HS code in that year.
Is this an issue for an accurate regression? Would I need all of my variables at the country-year level and is it possible to collapse the import values to this level?
Thanks for your help.
James (total beginner if that isn't already obvious)
Related Posts with Constructing panel data set
Sending output to file _instead of_ Results windowI have a do-file that produces a lot of output from various types of commands. I would like to store…
Tabulating across variables after using multencodeHi Everyone, I have a string variable that contains multi-picklist values separated by a semi-colon…
How to superimpose grid on a mapHello Everyone I am trying to superimpose grid on my map in stata. I could not find proper way of do…
custom xline value per group in xtlineHi. I'm trying to produce a graph for each US state using -xtline- and the -xline- option (Stata 15.…
Combining graphs from a loopHi, I am making histograms using the following command that I want to loop for 122 countries, Code…
Subscribe to:
Post Comments (Atom)
0 Response to Constructing panel data set
Post a Comment