======================================================================== July 1994 updated April 2002 Baldwin-Green Study Canada-US Census of Industry 1867 - 1940 See Documentation held in Social Science Data Centre Documents Unit, Queen's University Kingston, Ontario K7L 5C4 Documentation Call No.: CA2 ON UQ 90C17 Vols 1 & 2 COMPARISON OF CANADIAN AND U.S. INDUSTRY: 2-DIGIT SIC CODES, 1867-1940 -- CANADIAN DATA -- FILE NAME: MERGCA.txt CONTENTS: Documentation for the file "MERGCA.xls" (Microsoft Excel 2000) File resaved in MS-EXCEL 2000 format in April 2002 This file documents the column headings found in the spreadsheet files listed above. All files listed here are identical -- they have just been saved in different spreadsheet formats. OVERVIEW: "MERGCA.xls" is the final merged file for the CANADIAN data from the Green-Baldwin SSHRC project conducted in the 1980's. These data represent the final merged file for the CANADA-US MANUFACTURING COMPARISON at the 2-digit SIC code level. Data span from 1870 to 1940. A series of historical price indices for various industries have been included, covering the period 1867 to 1940. They originated from Urquhart and Buckley(ed), HISTORICAL STATISTICS OF CANADA, VOL. I, series J34-44. This data is located in the last few columns. FILE CREATION: Data were transferred from a SAS 82.3 print output dated 1987. The work of transferring these data was done by Mark Smith, a graduate student in Economics, in January 1994. ACKNOWLEDGEMENTS: The Baldwin-Green project was graciously supported by SSHRC Grant # 410-83-0439 R-1. For more complete information on matchings, sources and derivation of the numbers, see the 'Background' binders available from Queen's Professor Alan G. Green or the Queen's Documents Library. The corresponding paper written by Baldwin and Green, for the Belagio Conference in 1986, exists only in hard copy form, and may be available from Professor Green. A copy of this paper has been added to the data file documentation in the Documents Library. HEADINGS: Each industry has a similar set of headings, with different individual industry codes. Replace the asterisk with the appropriate industry code (see next section). 1) Number of establishments NEST* 2) Number of employees NEMP* 3) Salary and wages SAW* 4) Gross Value of Production GRPRO* 5) Cost of materials used CMAT* 6) Value added VA* 7) Average value added AVA* = [VA*/NEST*] 8) Average value of gross production AGRPRO* = [GRPRO*/NEST*] INDUSTRY CODES: Each Canadian variable has an extra letter added to the end of the variable name, which relates it to its industry. The following letter codes have been used: Code Example Industry ---- ------- -------- S VAS TRANSPORTATION EQUIPMENT W VAW WOOD T VAT TOBACCO PRODUCTS F VAF FOOD AND BEVERAGE K VAK KNITTING MILLS (Note: Doesn't generate AVA or AGRPRO) (note: does not include VAK or AVAK) I VAI IRON AND STEEL PRODUCTS L VAL LEATHER Z VAZ MISCELLANEOUS MAUFACTURING M VAM NON-METALLIC MINERALS N VAN NON-FERROUS METALS P VAP PAPER AND ALLIED INDUSTRIES O VAO PETROLEUM AND COAL PRODUCTS R VAR RUBBER AND PLASTICS X VAX TEXTILES B VAB PRINTING AND PUBLISHING H VAH CHEMICAL PRODUCTS C VAC CLOTHING INDUSTRY E VAE ELECTRICAL PRODUCTS PRICE INDICES: The following price indices are included in the file: Industry Index label _______________________________________________ General index for Canada, including gold.......... GENC Vegetable products............. VEGC Animal products................ ANIMC Chemical industries............ CHEMC Non-ferrous metals............. NFERC Non-metalic minerals NMETC Wood and allied industries WOODC Textiles and Allied Industies TEXTC Vegetable products VEGC Iron and steel Industry IRONC General Manufacturing GENC The following variables are the numbers from above, divided by 100. NEWANIMC NEWCHEMC NEWNFERC NEWNMETC NEWWOODC NEWTEXTC NEWVEGC NEWIRONC NEWGENC