Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Merge Question


From   "Dimitriy V. Masterov" <dvmaster@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Merge Question
Date   Fri, 1 Sep 2006 23:45:16 -0400

Chris,

It's hard to give advice without exactly knowing what your data sets
look like, but I would

(1) transform your WB data like I do with the fake data below, save it
as new_data.dta and clear
(3) Open first_data.dta and sort by country and year
(4) merge using country year using C:/.../new_data.dta

Here's the code to inspire step 1:

/* Make Fake Data */
clear
set obs 10
gen year=2000+_n

foreach country in Atlantis Tuvalu Abusrdistan Paradiseland {
	gen `country'=uniform()
}


/* Rename Each Country as x1,... */
local i=1
foreach country in Atlantis Tuvalu Abusrdistan Paradiseland {
	rename `country' x`i'
	local n`i' "`country'"
	local i=`i'+1
}

/* Reshape Data */
reshape long x, i(year) j(country)

/* Label The Countries */
qui sum country
forvalues j=`r(min)'/`r(max)' {
	label define countrylbl `j' "`n`j''", modify
}
lab val country countrylbl

sort country year
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index