Hi all!
So I am a bit stuck on something I have to do.
1. I have a dataset which is multi level, and includes several individual observations for different countries (total 40), for different years/waves. (So for each year, there are 40 countries each having several individual observations of its own). So this is an individual level file.
2. In another dataset, I have the country level variables for all these countries and many more, which has variables like gdp of the country in that particular year
3. I have created an id variable - such that (country-wave) which is the same in both the files.
SO if the code is 47, it represents for country 4 in wave 7.
I want to import the gdp values for each country-wave variable from dataset in 2. such that it gets inputed into all the individual level observations corresponding to that particular (country-wave) variable.
All i need is a loop code such that it would take the gdp value corresponding to the country-wave number (e.g. 47) and put it into the individual file for observations that also correspond to the same country-wave number.
These are two different stata files.
Please help if you can! Will be very well appreciated.
Related Posts with Looping in Stata to extract values from one file to another
problem plotting latitude and longitude using grmapDear Statalists, I am having some problem in plotting latitude and longitude on a map I have perform…
Replicate TableHello, I am trying to replicate the below table, but I'm not sure which command to use. The "final …
question on Use logical expressions and sum()This question is from N. J. Cox's article: https://journals.sagepub.com/doi/pdf...867X1101100210. Se…
Dropping Variables with Multiple Conditions.Hi, Statalist. I'm trying to clean a dataset. This is a small snippet below...I deleted some variabl…
Relabeling ValuesThis is my first time using Stata without help from a professor, and I am struggling to relabel my v…
Subscribe to:
Post Comments (Atom)
0 Response to Looping in Stata to extract values from one file to another
Post a Comment