X-Sender: arose@haas.berkeley.edu
X-Mailer: QUALCOMM Windows Eudora Version 5.1
Date: Mon, 28 Jan 2002 08:49:31 -0800
To: tenreyro@fas.harvard.edu
From: Andrew Rose <arose@haas.berkeley.edu>
Subject: More on Missing Currency Union Observations
Cc: arose@haas.berkeley.edu
I’ve now checked a little further into the issue of missing data (I’ll post my data set on the web within the hour). The IMF’s Direction of Trade seems like it may have fewer missing observations than the WTDB.
In my (DoT) data set, I have observations for 18 of the 20 years for bilateral trade between CAR and Chad (you assert that the WTDB only has 9), and for 17 of the 20 for trade between CAR and Cote d’Ivoire (you only have 12). I list the observations in my program pst2 (which I both attach and append at the bottom of this message).
Now I don’t have the most up to date version of the WTDB CDs. I have the 1997 ones distributed to NBER members which only go to 1992. For that, there are observations for only 4 years between CAR (country code 141400) and Chad (141480), and 8 years between CAR and Cote d’Ivoire (163840). The years also line up closely (though not exactly) with the ones you mention in your paper on p 14. The following are extracts from the file WT_BILAT.ASC:
141400 141480 177 78
141400 141480 226 79
141400 141480 253 80
141400 141480 1669 89
141480 141400 1635 78
141480 141400 563 79
141480 141400 485 80
141480 141400 90 89
141400 163840 715 78
141400 163840 1504 79
141400 163840 523 80
141400 163840 687 81
141400 163840 379 82
141400 163840 385 83
141400 163840 473 85
141400 163840 996 89
163840 141400 85 78
163840 141400 271 79
163840 141400 959 80
163840 141400 275 81
163840 141400 307 82
163840 141400 136 83
163840 141400 16 85
So it seems like the WTDB simply has fewer observations that the DoT data set. Using either data sampled every 5 years, or temporally averaged data, the DoT gives no indication that missing observations are the source of any bias for the effect of CU on trade.
What do you think? Over to you —
——————————————————————————-
log: C:\res\cuts\progs\pst2.log
log type: text
opened on: 28 Jan 2002, 08:26:05
. *
. * This STATA program tabulates data for the CFA countries that
. * Tenreyro lists on her page 14.
. *
. set more 1
. set mem 100m
(102400k)
. *
. * Read in the data set
. *
. use \res\cuts\data\data7ast
. *
. * List the data. CAR is 626; Chad is 628 and Cote d’ivoire is 662.
. *
. * CAR and Chad post ’77
. *
. list trade year if cty1==626&cty2==628&year>1977
trade year
- 13135.78 1978
- 5194.03 1979
- 4709.69 1980
- 15586.78 1981
- 15437.03 1982
- 0 1983
- 0 1984
- 1260.603 1985
- 1327.313 1986
- 1536.399 1987
- 1845.313 1988
- 1936.965 1989
- 2112.938 1990
- 2549.745 1991
- 2861.125 1992
- 2040.026 1993
- 4803.166 1994
- 6077.008 1995
- 6947.66 1996
- 7467.592 1997
. *
. * CAR and Cote d’Ivoire post ’77
. *
. list trade year if cty1==626&cty2==662&year>1977
trade year
- 4536.978 1978
- 10388.06 1979
- 7823.185 1980
- 5707.478 1981
- 3040.401 1982
- 2811.715 1983
- 0 1984
- 4135.688 1985
- 16186.92 1986
- 0 1987
- 0 1988
- 3899.983 1989
- 2558.077 1990
- 1420.624 1991
- 27314.09 1992
- 21383.65 1993
- 29571.58 1994
- 51312.94 1995
- 128071.6 1996
- 137655.7 1997
. *
. * Clean up and close down
. *
. drop _all
. set more 0
. set mem 1m
(1024k)
. log close
log: C:\res\cuts\progs\pst2.log
log type: text
closed on: 28 Jan 2002, 08:27:51
——————————————————————————-
********
Andrew K. Rose, Rocca Professor Tel: (510) 642-6609
Haas School of Business Fax: (510) 642-4700
University of California E-mail: arose@haas.berkeley.edu
Berkeley, CA 94720-1900 URL: http://faculty.haas.berkeley.edu/arose