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
Panel data: xtoverid rejects RE for model with only time controls; odd result or information?Dear Statalisters, I am using interrupted time series methods on household panel data. I have month…
Loop for moving rangeGoodafternoon, I have a file which includes a significant amount of cusips (S&P1500) and dates …
How to change a line pattern within a same graph? Hi, I would like to plot a graph using Code: twoway line and draw a different graph pattern after …
Creating new outcome variable - invalid syntax r(198) problemI have twelve disease variables in my dataset. I want to to create an outcome variable "multimorbidi…
Confusing behavior by ustrregexs()I'm trying to use ustrregexs to extract substrings from a string. With the data below: Code: clear…
Subscribe to:
Post Comments (Atom)
0 Response to Looping in Stata to extract values from one file to another
Post a Comment