These are the Stata commands used to generate Tables 1 and 2 in the article, "Do Donors Care about  
Declining Trade Revenue from Liberlization? An Analysis of Bilateral Aid Allocation" 
by Javed Younad and Subhayu Bandyopadhyay for the
May/June 2009, Vol. 91(3) issue of the Federal Reserve Bank of St. Louis Review.

See the excel data file for the variables and their descriptions. 

Sata 8.0 was used to derive the estimation results. 

/* Change data-tabeles1&2 file name and save as foreignaidtrade.csv */

/* Note: 1) Most basic calculations to generate new variables from
  the data were made directly in the excel data file; 2) Figures formulated using excel*/ 

insheet using c:\data\foreignaidtrade.csv, clear

set matsize 800
iis countryi
tis year
gen lnpop2=(lnpop)^2
gen lngdppc2=(lngdppc)^2

/* Table 1: Without Fixed Effects - Trade Tax Revenue on levels */

xtgls lnrbaid lnpop lnpop2 lngdppc lngdppc2 lninfmor lnprcl lnimpdutrev lnrmaid y2-y12, i(countryi) t(year) p(h) force
xtgls lnrbaid lnpop lnpop2 lngdppc lngdppc2 lninfmor lnprcl lninttaxrev lnrmaid y2-y12, i(countryi) t(year) p(h) force

/* Table 1: With Fixed Effects - Trade Tax Revenue on levels */

xtgls lnrbaid lnpop lnpop2 lngdppc lngdppc2 lninfmor lnprcl lnimpdutrev lnrmaid y2-y12 c2-c52, i(countryi) t(year) p(h) force
xtgls lnrbaid lnpop lnpop2 lngdppc lngdppc2 lninfmor lnprcl lninttaxrev lnrmaid y2-y12 c2-c52, i(countryi) t(year) p(h) force

/* Table 2: Without Fixed Effects - Ratio of Trade Tax Revenue to Total Tax Revenue */

xtgls lnrbaid lnpop lnpop2 lngdppc lngdppc2 lninfmor lnprcl impdutrevr lnrmaid y2-y12, i(countryi) t(year) p(h) force
xtgls lnrbaid lnpop lnpop2 lngdppc lngdppc2 lninfmor lnprcl inttaxrevr lnrmaid y2-y12, i(countryi) t(year) p(h) force

/* Table 2: With Fixed Effects - Ratio of Trade Tax Revenue to Total Tax Revenue */

xtgls lnrbaid lnpop lnpop2 lngdppc lngdppc2 lninfmor lnprcl impdutrevr lnrmaid y2-y12 c2-c52, i(countryi) t(year) p(h) force
xtgls lnrbaid lnpop lnpop2 lngdppc lngdppc2 lninfmor lnprcl inttaxrevr lnrmaid y2-y12 c2-c52, i(countryi) t(year) p(h) force