Statalist The Stata Listserver


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

st: Re: data management question


From   "Michael Blasnik" <michael.blasnik@verizon.net>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: data management question
Date   Tue, 31 Oct 2006 16:56:38 -0500

...
use masterdata
keep sourcecounty sourcegdp
rename sourcecountry destinationcountry
rename sourcegdp destinationgdp
bysort destinationcountry: keep if _n==1
sort destinationcountry
save gdps

use masterdata
sort destinationcountry
merge destinationcountry using gdps, nokeep
tab _merge
* check that all countries are there
drop _merge


Michael Blasnik


----- Original Message ----- From: "Simo Hansen" <simohansen@gmail.com>
To: <statalist@hsphsun2.harvard.edu>
Sent: Tuesday, October 31, 2006 4:38 PM
Subject: st: data management question



Dear All,
I have the following data set:

SourceCountry DestinationCountry Source CountryGDP Destination CountryGDP
USA USA 100
USA ENGLAND 100
USA FRANCE 100
ENGLAND USA 75
ENGLAND ENGLAND 75
ENGLAND FRANCE 75
FRANCE USA 50
FRANCE ENGLAND 50
FRANCE FRANCE 500

My goal is to create a column for Destination Country GDP using information
in the column of Source Country. My data should look like in the following
form:
SourceCountry DestinationCountry Source CountryGDP DestinationCountryGDP
USA USA 100
100
USA ENGLAND 100 75

USA FRANCE 100 50

ENGLAND USA 75 100
ENGLAND ENGLAND 75 75
ENGLAND FRANCE 75 50
FRANCE USA 50 100

FRANCE ENGLAND 50 75
FRANCE FRANCE 50 50
Unortunayely, I cannot figure out how to this. Any help would be greatly
appreciated.
Best regards,
Simo
*
*   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