The data I am working with is a very large dataset: the MIT Atlas data recording product trade by origin and destination country by year by product. I have combined it with CEPII data to determine how far apart each two countries are. My issue is this: I can successfully sum up exports by country to a given country, but my program does not do this for every country. The state of my current code gives me the sum of each country's exports to and imports from Zimbabwe, and stops there. What I need: the exports to and imports from each country A and country B. My current code: data sasuser.want;
set sasuser.have;
by origin destination year;
if First.destination then TotalExports = 0;
TotalExports +exports;
if Last.destination;
if First.origin then TotalImports = 0;
TotalImports + imports;
if Last.origin;
TotalTrade = TotalExports +TotalImports;
run; What's going wrong here? Any help would be greatly appreciated. I should note that I have successfully grabbed the data I want creating 2 separate datasets and then merging them. I am curious at this point about the feasability of doing this in a more concise manner.
... View more