Chris Magee
Department of Economics
Bucknell University
Lewisburg, PA 17837
E-mail: cmagee@bucknell.edu

Included are two Stata files. One is conmsic.dta, which is the file I created to map from msic industries on the cd-rom to sic industries. I describe it more below. The second file is tariffs.dta, which contains, for each SIC (1972 code) industry the calculated tariff, the real (1982 $) value of duties collected, the real customs value of imports, and the real cif value of imports.

I took the file SIC_MSIC.asc on the NBER disk to get a concordance between MSIC and SIC codes (1972 for both). If one MSIC industry mapped into two or more SIC industries(say sic1 and sic2), I created ratios:

ratio1 = shipment value(SIC1)/(ship value(sic1)+ship value(sic2)) 
and 
ratio2 = shipment value(SIC2)/(ship value(sic1)+ship value(sic2)).

The shipment values were taken from the Census of Manufactures, and I calculated separate ratios for each year. These ratios are on the file conmsic.sd2.

I then summed imports (customs value) and duties paid by 1972 msic industries off the imp*.asc files on the NBER disk. I multiplied each of these by the ratios calculated above and then summed by 1972 sic industries. The average tariff in each sic industry is equal to 100*(duties/customs value of imports). I only did this for 1974 - 1988 (as I recall, for 1972 and 1973 the duties collected data was missing). I converted all nominal values to 1982 $ using the CPI for all urban consumers.

One final note: One thing I noticed was that in 1977, many of the estimated tariffs fell precipitously from their 1976 levels and then rose back to the 1976 levels in 1978. On my data sets, I replaced the 1977 calculated tariff with the average of the 1976 and 1978 tariffs if the 1977 tariff fell to less than 1/5 of the 1976 level and then rose again to more than 5 times the 1977 level in 1978.

Documentation of conmsic.dta: This file contains:

msic72 = 1972 basis 4-digit import-based sic number 
sic72 = 1972 basis 4-digit SIC number 
ratio** = fraction of msic72 that maps into sic72 (defined above) in year **

Documentation of tariffs.dta: This file contains:

sic72 = 1972 based 4-digit SIC number 
rduty** = total duties collected (in 1982 $) on imports in sic72 in year ** 
rcust** = total customs value of imports (in 1982 $) in sic72 in year ** 
rcif** = total cif value of imports (in 1982 $) in sic72 in year ** 
tariff** = 100*rduty**/rcust** = average tariff in sic72 in year **

rduty, rcust, rcif are all in millions of 1982 $.