I have to different databases. Database 1 has executive actions in specific years, but this is not continuous (there may be an executive action in 2002 then nothing until 2004) Database 2 has country specific economic performance in specific years. I need somehow to match up the executive action score to the most recent event. So I have database 1 that looks like:
year | governance_score | country
1919 5 USA
1979 12 FRA
1988 10 USA
1988 3 DEU
2001 9 FRA
2005 11 DEU
And Database 2
year | country | GDP
1990 USA 290
1991 USA 292
1992 USA 294
1995 FRA 143
How can I keep the governance score consistent for each year after the active date until the country gets a subsequent score and match it to the country?
Thank you in advance for your help!
Related Posts with Matching Actions to Years
Displaying Significance Stars in combined summary and correlations tableDear Forum, i merged my correlations and summary statistics to one table via the below code (thanks…
Esttab: Store value of matrix and display in tex-tableDear All, I am encountering the following issue. I want to compute a mean after a regression with t…
R2 for xtnbreg modelHello everyone, i am currently analyzing a count variable with the -xtnbreg- command. This command …
Dumitrescu & Hurlin (2012) Granger non-causality testHello Dears, I am trying to see the granger causality between government revenue and government spen…
Missing valuesHello, fellow stata lovers! I am working on my thesis and have a dataset from the Enterprise Survey…
Subscribe to:
Post Comments (Atom)
0 Response to Matching Actions to Years
Post a Comment