set more 1 /* File: cepr_march_ind.do Date: May 1, 2010, CEPR March Version 0.9 Oct 5, 2011 Oct 12, 2012, CEPR March Version 0.9.6 Sep 27, 2013, CEPR March Version 0.9.7 June 9 2015, CEPR March Version 0.9.8 Sep 1 2015, CEPR March Version 0.9.8.1 Oct 1, 2015, CEPR March Version 0.9.9 Oct 13, 2015, CEPR March Version 0.9.9.1 Oct 13, 2016, CEPR March Version 1.0 Apr 11, 2019, CEPR March Version 1.1 Desc: Creates consistent industry variables for CEPR consistent extract of March CPS Note: See copyright notice at end of program. indly2d_* indly3d_*: from March CPS: Industry Last Year ind2d_* ind3d_*: from Basic CPS: Industry Last Week This program creates industry variables for jobs held last year and last week, pulled from March CPS and Basic CPS. Users may utilize variables accordingly. */ /* Determine survey year */ local year=year in 1 /* Consistent two-digit industry coding */ /* 1980 - 1982 (last year & last week) */ if `year'==1979 { gen byte ind2d_80=. gen byte ind2d_83=. gen byte ind2d_89=. gen byte ind2d_03=. gen byte indly2d_80=. gen byte indly2d_83=. gen byte indly2d_03=. } if 1980<=`year' & `year'<=1982 { gen indly2d_83=. gen indly2d_03=. rename indly2 indly2d_80 gen ind2d_83=. gen ind2d_89=. gen ind2d_03=. rename ind2d ind2d_80 } #delimit ; label define indly2d_80 0 "Never worked (Non March & CSA files)" 1 "Goods-producing industries -- Agric. production" 2 "Goods-producing industries -- Agric. services" 3 "Goods-producing industries -- Mining" 4 "Goods-producing industries -- Construction" 5 "Manufacturing (Durable goods) -- Ordinance" 6 "Manufacturing (Durable goods) -- Lumber" 7 "Manufacturing (Durable goods) -- Furniture" 8 "Manufacturing (Durable goods) -- Stone, clay, glass" 9 "Manufacturing (Durable goods) -- Primary metals" 10 "Manufacturing (Durable goods) -- Fabricated metals (inc not spec. metal)" 11 "Manufacturing (Durable goods) -- Machinery, exclude electrical" 12 "Manufacturing (Durable goods) -- Electrical equipment" 13 "Manufacturing (Durable goods) -- Transp equipment: Automobiles" 14 "Manufacturing (Durable goods) -- Transp equipment: Aircraft" 15 "Manufacturing (Durable goods) -- Transp equipment: Other" 16 "Manufacturing (Durable goods) -- Instruments" 17 "Manufacturing (Durable goods) -- Misc" 18 "Manufacturing (Nondurable goods) -- Food" 19 "Manufacturing (Nondurable goods) -- Tabacco" 20 "Manufacturing (Nondurable goods) -- Textiles" 21 "Manufacturing (Nondurable goods) -- Apparel" 22 "Manufacturing (Nondurable goods) -- Paper" 23 "Manufacturing (Nondurable goods) -- Printing" 24 "Manufacturing (Nondurable goods) -- Chemicals" 25 "Manufacturing (Nondurable goods) -- Petroleum" 26 "Manufacturing (Nondurable goods) -- Rubber and plastics" 27 "Manufacturing (Nondurable goods) -- Leather and not specfied manuf" 28 "Service Prod Industries -- Transp & public util. -- Postal" 29 "Service Prod Industries -- Transp & public util. -- Other transp" 30 "Service Prod Industries -- Transp & public util. -- Communications" 31 "Service Prod Industries -- Transp & public util. -- Other public util." 32 "Service Prod Industries -- Trade -- Wholesale" 33 "Service Prod Industries -- Trade -- Retail: Eating & drinking places" 34 "Service Prod Industries -- Trade -- Retail: Other" 35 "Finance, insurance, and real estate -- Banking & other finance" 36 "Finance, insurance, and real estate -- Insurance & real estate" 37 "Private household service" 38 "Misc. services -- Business & repair -- Business" 39 "Misc. services -- Business & repair -- Repair" 40 "Misc. services -- Personal services, except private household" 41 "Misc. services -- Entertainment & recreation" 42 "Misc. services -- Prof. services -- Medical, except hospitals" 43 "Misc. services -- Prof. services -- Hospitals" 44 "Misc. services -- Prof. services -- Welfare and religious" 45 "Misc. services -- Prof. services -- Educational" 46 "Misc. services -- Prof. services -- Other professional" 47 "Misc. services -- Forestry & Fisheries" 48 "Public admin. -- Postal" 49 "Public admin. -- Other federal" 50 "Public admin. -- State" 51 "Public admin. -- Local" 52 "Never worked (March & CSA files)" ; #delimit cr /* 1983 - 2002 (last year) */ if 1983<=`year' & `year'<=2002 { gen indly2d_80=. gen indly2d_03=. rename indly2 indly2d_83 } #delimit ; label define indly2d_83 1 "Agriculture" 2 "Mining" 3 "Construction" 4 "Manufacturing (Durable goods)-Lumber & wood products, except furniture" 5 "Manufacturing (Durable goods)-Furniture and fixtures" 6 "Manufacturing (Durable goods)-Stone clay, glass and concrete product" 7 "Manufacturing (Durable goods)-Primary metals" 8 "Manufacturing (Durable goods)-Fabricated metal" 9 "Manufacturing (Durable goods)-Not specified metal industries" 10 "Manufacturing (Durable goods)-Machinery, except electrical" 11 "Manufacturing (Durable goods)-Electrical Machinery, equipment, & supplies" 12 "Manufacturing (Durable goods)-Motor vehicles and equipment" 13 "Manufacturing (Durable goods)-Aircrafts and parts" 14 "Manufacturing (Durable goods)-Other transportation equipment" 15 "Manufacturing (Durable goods)-Professional and photographic equipment" 16 "Manufacturing (Durable goods)-Toys, amusements ,and sporting goods" 17 "Manufacturing (Durable goods)-Misc. & not specified manuf industries" 18 "Manufacturing (Nondurable goods)-Food & kindred products" 19 "Manufacturing (Nondurable goods)-Tobacco manufactures" 20 "Manufacturing (Nondurable goods)-Textile mill products" 21 "Manufacturing (Nondurable goods)-Apparel & other finished textile prod." 22 "Manufacturing (Nondurable goods)-Paper & allied products" 23 "Manufacturing (Nondurable goods)-Printing, publishing & allied industries" 24 "Manufacturing (Nondurable goods)-Chemicals & allied products" 25 "Manufacturing (Nondurable goods)-Petroleum & coal products" 26 "Manufacturing (Nondurable goods)-Rubber & misc. plastics products" 27 "Manufacturing (Nondurable goods)-Leather & leather products" 28 "Transportation" 29 "Communications" 30 "Utilities and Sanitary Services" 31 "Wholesale Trade" 32 "Retail Trade" 33 "Banking and Other Finance" 34 "Insurance and Real Estate" 35 "Private Household Services" 36 "Business Services" 37 "Repair Services" 38 "Personal Services, Except Private Household" 39 "Entertainment and Recreation Services" 40 "Hospitals" 41 "Health Services, Except Hospitals" 42 "Educational Services" 43 "Social Services" 44 "Other professional Services" 45 "Forestry and Fisheries" 46 "Public Administration" 47 "Never worked/ last job armed forces" ; #delimit cr /* 1983 - 1988 (last week)*/ if 1983<=`year' & `year'<=1988 { gen ind2d_80=. gen ind2d_89=. gen ind2d_03=. rename ind2d ind2d_83 } /* 1989 - 2002 (last week)*/ if 1989<=`year' & `year'<=2002 { gen ind2d_80=. gen ind2d_83=. gen ind2d_03=. rename ind2d ind2d_89 replace ind2d_89=. if ind2d_89==99 } #delimit ; label define ind2d_89 0 "Never Worked" 1 "Agriculture Service" 2 "Other Agriculture" 3 "Mining" 4 "Construction" 5 "Lumber and wood products , except furniture" 6 "Furniture and fixtures" 7 "Stone clay ,glass and concrete product" 8 "Primary metals" 9 "Fabricated metal" 10 "Not specified metal industries" 11 "Machinery, except electrical" 12 "Electrical Machinery, equipment ,and supplies" 13 "Motor vehicles and equipment" 14 "Aircrafts and parts" 15 "Other transportation equipment" 16 "Professional and photographic equipment" 17 "Toys, amusements ,and sporting goods" 18 "Miscellaneous and not specified manufacturing industries" 19 "Food and kindred products" 20 "Tobacco manufactures" 21 "Textile mill products" 22 "Apparel and other finished textile prod." 23 "Paper and allied products" 24 "Printing ,publishing and allied industries" 25 "Chemicals and allied products" 26 "Petroleum and coal products" 27 "Rubber and miscellaneous plastics products" 28 "Leather and leather products" 29 "Transportation" 30 "Communications" 31 "Utilities and Sanitary Services" 32 "Wholesale Trade" 33 "Retail Trade" 34 "Banking and Other Finance" 35 "Insurance and Real Estate" 36 "Private Household Services" 37 "Business Services" 38 "Automobile and repair services" 39 "Personal Services , Except Private Household" 40 "Entertainment and Recreation Services" 41 "Hospitals" 42 "Health Services , Except Hospitals" 43 "Educational Services" 44 "Social Services" 45 "Other professional Services" 46 "Forestry and Fisheries" 47 "Justice, public order and safety" 48 "Administration of human resource programs" 49 "National security and internal affairs" 50 "Other public administration" 51 "Armed forces last job; currently unemployed" ; #delimit cr /* 2003 - present (last year) */ if 2003<=`year' & `year'<=2013 { gen indly2d_80=. gen indly2d_83=. rename indly2 indly2d_03 replace indly2d_03=. if indly2d_03<=0 } if 2014<=`year' & `year'<=2018 { gen indly2d_80=. gen indly2d_83=. gen byte indly2d_03=weind replace indly2d_03=. if indly2d_03<=0 } #delimit ; label define indly2d_03 1 "Agriculture, forestry, fishing, and hunting" 2 "Mining" 3 "Construction" 4 "Durable goods manufacturing" 5 "Non-durable goods manufacturing" 6 "Wholesale trade" 7 "Retail trade" 8 "Transportation and warehousing" 9 "Utilities" 10 "Information" 11 "Finance and insurance" 12 "Real estate and rental and leasing" 13 "Professional, scientific, and technical services" 14 "Management, admin. support, and waste management services" 15 "Educational services" 16 "Health care and social assistance" 17 "Art, entertainment, and recreation" 18 "Accommodations and food services" 19 "Private households" 20 "Other services, except private households" 21 "Public administration" 22 "Armed Forces and active military" 23 "Never worked" ; #delimit cr /* 2003 - (last week)*/ if 2003<=`year' & `year'<=2013 { gen ind2d_80=. gen ind2d_83=. gen ind2d_89=. rename ind2d ind2d_03 replace ind2d_03=. if ind2d_03<1 } if 2014<=`year' & `year'<=2018 { gen ind2d_80=. gen ind2d_83=. gen ind2d_89=. gen byte ind2d_03=a_dtind replace ind2d_03=. if ind2d_03<1 } #delimit ; label define ind2d_03 1 "Agriculture" 2 "Forestry, logging, fishing, hunting, and trapping" 3 "Mining" 4 "Construction" 5 "Nonmetallic mineral product manufacturing" 6 "Primary metals and fabricated metal products" 7 "Machinery manufacturing" 8 "Computer and electronic product manufacturing" 9 "Electrical equipment, appliance manufacturing" 10 "Transportation equipment manufacturing" 11 "Wood products" 12 "Furniture and fixtures manufacturing" 13 "Miscellaneous and not specified manufacturing" 14 "Food manufacturing" 15 "Beverage and tobacco products" 16 "Textile, apparel, and leather manufacturing" 17 "Paper and printing" 18 "Petroleum and coal products manufacturing" 19 "Chemical manufacturing" 20 "Plastics and rubber products" 21 "Wholesale trade" 22 "Retail trade" 23 "Transportation and warehousing" 24 "Utilities" 25 "Publishing industries (except internet)" 26 "Motion picture and sound recording industries" 27 "Broadcasting (except internet)" 28 "Internet publishing and broadcasting" 29 "Telecommunications" 30 "Internet service providers and data processing services" 31 "Other information services" 32 "Finance" 33 "Insurance" 34 "Real estate" 35 "Rental and leasing services" 36 "Professional and technical services" 37 "Management of companies and enterprises" 38 "Administrative and support services" 39 "Waste management and remediation services" 40 "Educational services" 41 "Hospitals" 42 "Health care services, except hospitals" 43 "Social assistance" 44 "Arts, entertainment, and recreation" 45 "Accommodation" 46 "Food services and drinking places" 47 "Repair and maintenance" 48 "Personal and laundry services" 49 "Membership associations and organizations" 50 "Private households" 51 "Public administration" 52 "Armed forces" ; #delimit cr lab var ind2d_80 "2-digit industry, last week" lab val ind2d_80 indly2d_80 notes ind2d_80: Available 1983-1988 notes ind2d_80: Not compatible with ind2d_83, ind2d_89, ind2d_03 notes ind2d_80: CPS: rcdeind a-dtind lab var ind2d_83 "2-digit industry, last week" lab val ind2d_83 indly2d_83 notes ind2d_83: Available 1983-1988 notes ind2d_83: Not compatible with ind2d_80, ind2d_89, ind2d_03 notes ind2d_83: CPS: rcdeind a-dtind lab var ind2d_89 "2-digit industry, last week" lab val ind2d_89 ind2d_89 notes ind2d_89: Available 1989-2002 notes ind2d_89: In 1988B-1992, Forestry is recoded to 46 notes ind2d_89: In 1993-1997, Forestry (part of 46) is recoded to /* */ 1 (Agriculture Service) notes ind2d_89: In 1988B-1992, Automotive services, except repair /* */ is recoded to 38 (Automobile and repair services) notes ind2d_89: In 1993-1997, Automative services, except repair /* */ (part of 38) is recoded to 37 (Business Services) notes ind2d_89: Not compatible with ind2d_80, ind2d_83, ind2d_03 notes ind2d_89: CPS: rcdeind a-dtind lab var ind2d_03 "2-digit industry, last week" lab val ind2d_03 ind2d_03 notes ind2d_03: Available 2003 - notes ind2d_03: Not compatible with ind2d_80, ind2d_83, ind2d_89 notes ind2d_03: CPS: rcdeind a-dtind lab var indly2d_80 "2-digit industry, last year" lab val indly2d_80 indly2d_80 notes indly2d_80: Available 1980-1982 notes indly2d_80: Not compatible with indly2d_83, indly2d_03 notes indly2d_80: March CPS: r-weind weind lab var indly2d_83 "2-digit industry, last year" lab val indly2d_83 indly2d_83 notes indly2d_83: Available 1983-2002 notes indly2d_83: In 1988B-1992, Forestry is recoded to 45 notes indly2d_83: In 1993-1997, Forestry (part of 45) is recoded to /* */ 1 (Agriculture) notes indly2d_83: Not compatible with indly2d_80, indly2d_03 notes indly2d_83: March CPS: r-weind weind lab var indly2d_03 "2-digit industry, last year" lab val indly2d_03 indly2d_03 notes indly2d_03: Available 2003 - notes indly2d_03: Not compatible with indly2d_80, indly2d_83 notes indly2d_03: March CPS: r-weind weind /* Three-digit industry */ /* 1980-1982 (last year & last week) */ if `year'==1979 { gen byte ind3d_80=. gen byte ind3d_83=. gen byte ind3d_92=. gen byte ind3d_03=. gen byte ind3d_13=. gen byte ind3d_14=. gen byte indly3d_80=. gen byte indly3d_83=. gen byte indly3d_92=. gen byte indly3d_03=. gen byte indly3d_13=. gen byte indly3d_14=. } if 1980<=`year' & `year'<=1982 { capture gen ind3d_83=. gen ind3d_92=. gen ind3d_03=. gen ind3d_13=. gen ind3d_14=. rename ind ind3d_80 capture gen indly3d_83=. gen indly3d_92=. gen indly3d_03=. gen indly3d_13=. gen indly3d_14=. rename indlyr indly3d_80 } #delimit ; lab def ind3d_80 17 "Agricultural production (01)" 18 "Agricultural services, except horticultural (07 except 0713 and 073)" 19 "Horticultural services (073)" 27 "Forestry (08)" 28 "Fisheries (09)" 29 "Agriculture, forestry, and fisheries--allocated" 47 "Metal mining (10)" 48 "Coal mining (11, 12)" 49 "Crude petroleum and natural gas extractions (13)" 57 "Nonmetallic mining and quarrying, except fuel (14)" 58 "Mining--allocated" 67 "General building contractors (15)" 68 "General contractors, except building (16)" 69 "Special trade contractors (17)" 77 "Not specified construction" 78 "Construction--allocated" 107 "Logging (241)" 108 "Sawmills, planing mills, and mill work (242, 243)" 109 "Miscellaneous wood products (244,249)" 118 "Furniture and fixtures (25)" 119 "Glass and glass products (321-323)" 127 "Cement, concrete, gypsum, and plaster products (324, 327)" 128 "Structural clay products (325)" 137 "Pottery and related products (326)" 138 "Miscellaneous nonmetallic mineral and stone products (328, 329)" 139 "Blast furnaces, steel works, rolling and finishing mills (3312,3313)" 147 "Other primary iron and steel industries (3315-3317, 332, 3391, pt3399)" 148 "Primary aluminum industries (3334, part 334, 3352, 3361, pt3392,pt3399" 149 "Othprinonferrind.(3331-3,3339,3351,3356,3357,3362,3369,ptof334/3392/3399)" 157 "Cutlery, hand tools, and other hardware (342)" 158 "Fabricated structural metal products (344)" 159 "Screw machine products (345)" 167 "Metal stamping (346)" 168 "Miscellaneous fabricated metal products (341, 343, 347, 348, 349)" 169 "Not specified metal industries" 177 "Engines and turbines (351)" 178 "Farm machinery and equipment (352)" 179 "Construction and material handling machines (353)" 187 "Metalworking machinery (354)" 188 "Office and accounting machines (357 except 3573)" 189 "Electronic computing equipment (3573)" 197 "Machinery, except electrical, n.e.c. (355, 356, 358, 359)" 198 "Not specified machinery" 199 "Household appliances (363)" 207 "Radio, T.V., and communication equipment (365, 366)" 208 "Elec. mach., equip., and supplies, n.e.c. (361,362,364,367,369)" 209 "Not specified electrical machinery, equipment, and supplies" 219 "Motor vehicles and motor vehicle equipment (371)" 227 "Aircraft and parts (372)" 228 "Ship and boat building and repairing (373)" 229 "Railroad locomotives and equipment (374)" 237 "Mobile dwellings and campers (3791)" 238 "Cycles and miscellaneous transportation equipment (375, 3799)" 239 "Scientific and controlling instruments (381, 382)" 247 "Optical and health services supplies (383, 384, 385)" 248 "Photographic equipment and supplies (386)" 249 "Watches, clocks, and clockwork-operated devices (387)" 257 "Not specified professional equipment" 258 "Ordnance (19)***" 259 "Miscellaneous manufacturing industries (39)" 267 "Manufacturing, durable goods--allocated" 268 "Meat products (201)" 269 "Dairy products (202)" 278 "Canning and preserving fruits, vegetables, and sea foods (203)" 279 "Grain-mill products (204, 0713)" 287 "Bakery products (205)" 288 "Confectionery and related products (207)" 289 "Beverage industries (208)" 297 "Miscellaneous food preparation and kindred products (206,209)" 298 "Not specified food industries" 299 "Tobacco manufactures (21)" 307 "Knitting mills (225)" 308 "Dyeing and finishing textiles, except wool and knit goods (226)" 309 "Floor coverings, except hard surface (227)" 317 "Yarn, thread, and fabric mills (221-224, 228)" 318 "Miscellaneous textile mill products (229)" 319 "Apparel and accessories (231-238)" 327 "Miscellaneous fabricated textile products (239)" 328 "Pulp, paper, and paperboard mills (261-263, 266)" 329 "Miscellaneous paper and pulp products (264)" 337 "Paperboard containers and boxes (265)" 338 "Newspaper publishing and printing (271)" 339 "Printing, publishing, and allied industries, except newspapers (272-279)" 347 "Industrial chemicals (281)" 348 "Plastics,synthetics and resins,except fibers (282, except 2823 and 2824)" 349 "Synthetic fibers (2823, 2824)" 357 "Drugs and medicines (283)" 358 "Soaps and cosmetics (284)" 359 "Paints, varnishes, and related products (285)" 367 "Agricultural chemicals (287)" 368 "Miscellaneous chemicals (286, 289)" 369 "Not specified chemicals and allied products" 377 "Petroleum refining (291)" 378 "Miscellaneous petroleum and coal products (295, 299)" 379 "Rubber products (301-303, 306)" 387 "Miscellaneous plastic products (307)" 388 "Tanned, curried, and finished leather (311)" 389 "Footwear, except rubber (313, 314)" 397 "Leather products, except footwear (312, 315-317, 319)" 399 "Manufacturing, nondurable goods--allocated" 398 "NOT SPECIFIED MANUFACTURING INDUSTRIES" 407 "Railroads and railway express service (40)" 408 "Street railways and bus lines (411, 413-415, 417)" 409 "Taxicab service (412)" 417 "Trucking service (421,423)" 418 "Warehousing and storage (422)" 419 "Water transportation (44)" 427 "Air transportation (45)" 428 "Pipe lines, except natural gas (46)" 429 "Services incidental to transportation (47)" 447 "Radio broadcasting and television (483)" 448 "Telephone (wire and radio) (481)" 449 "Telegraph and miscellaneous communication services (482, 489)" 467 "Electric light and power (491)" 468 "Electric-gas utilities (493)" 469 "Gas and steam supply systems (492, 496)" 477 "Water supply (494)" 478 "Sanitary services (495)" 479 "Other and not specified utilities (497)" 499 "Transportation, communications, and other public utilities--allocated" 507 "Motor vehicles and equipment (501)" 508 "Drugs, chemicals and allied products (502)" 509 "Dry goods and apparel (503)" 527 "Food and related products (504)" 528 "Farm products--raw materials (505)" 529 "Electrical goods (506)" 537 "Hardware, plumbing, and heating supplies (507)" 538 "Not specified electrical and hardware products" 539 "Machinery equipment and supplies (508)" 557 "Metals and minerals, n.e.c. (5091)" 558 "Petroleum products (5092)" 559 "Scrap and waste materials (5093)" 567 "Alcoholic beverages (5095)" 568 "Paper and its products (5096)" 569 "Lumber and construction materials (5098)" 587 "Wholesalers, n.e.c. (5094, 5097, 5099)" 588 "Not specified wholesale trade" 599 "Wholesale trade--allocated" 607 "Lumber and building material retailing (521-524)" 608 "Hardware and farm equipment stores (525)" 609 "Department and mail order establishments (531, 532)" 617 "Limited price variety stores (533)" 618 "Vending machine operators (534)" 619 "Direct selling establishments (535)" 627 "Miscellaneous general merchandise stores (539)" 628 "Grocery stores (541)" 629 "Dairy products stores (545)" 637 "Retail bakeries (546)" 638 "Food stores, n.e.c. (542-544, 549)" 639 "Motor vehicle dealers (551, 552)" 647 "Tire, battery, and accessory dealers (553)" 648 "Gasoline service stations (554)" 649 "Miscellaneous vehicle dealers (559)" 657 "Apparel and accessories stores, except shoe stores (56 except 566)" 658 "Shoe stores (566)" 667 "Furniture and home furnishings stores (571)" 668 "Household appliances, TV, and radio stores (572, 573)" 669 "Eating and drinking places (58)" 677 "Drug stores (591)" 678 "Liquor stores (592)" 679 "Farm and garden supply stores (596)" 687 "Jewelry stores (597)" 688 "Fuel and ice dealers (598)" 689 "Retail florists (5992)" 697 "Miscellaneous retail stores (593-595, 599 exc. 5992)" 698 "Not specified retail trade" 699 "Retail trade--allocated" 707 "Banking (60)" 708 "Credit agencies (61)" 709 "Security, commodity brokerage, and investment companies (62, 67)" 717 "Insurance (63, 64)" 718 "Real estate, incl. real estate-insurance-law offices (65, 66)" 719 "Finance, insurance, and real estate--allocated" 727 "Advertising (731)" 728 "Services to dwellings and other buildings (734)" 729 "Commercial research, development, and testing labs (7391, 7397)" 737 "Employment and temporary help agencies (736, 7398)" 738 "Business management and consulting services (part 7392)" 739 "Computer programing services (part 7392)" 747 "Detective and protective services (7393)" 748 "Business services, n.e.c. (732, 733, 735, 7394, 7395, 7396, 7399)" 749 "Automobile services, except repair (751, 752, 754)" 757 "Automobile repair and related services (753)" 758 "Electrical repair shops (762, 7694)" 759 "Miscellaneous repair services (763, 764, 769, except 7694)" 767 "Business and repair services--allocated" 769 "Private households (88)" 777 "Hotels and motels (701)" 778 "Lodging places, except hotels and motels (702, 703, 704)" 779 "Laundering, cleaning, and other garment services (721, 727)" 787 "Beauty shops (723)" 788 "Barber shops (724)" 789 "Shoe repair shops (725)" 797 "Dressmaking shops (part 729)" 798 "Miscellaneous personal services (722, 726, part 729)" 799 "Personal services--allocated" 807 "Theaters and motion pictures (78, 792)" 808 "Bowling alleys, billiard and pool parlors (793)" 809 "Miscellaneous entertainment and recreation services (791, 794)" 817 "Entertainment and recreation services--allocated" 828 "Offices of physicians (801, 803)" 829 "Offices of dentists (802)" 837 "Offices of chiropractors (804)" 838 "Hospitals (806)" 839 "Convalescent institutions (8092)" 847 "Offices of health practitioners, n.e.c. (part 8099)" 848 "Health services, n.e.c. (807, part 8099)" 849 "Legal services (81)" 857 "Elementary and secondary schools (821)" 858 "Colleges and universities (822)" 859 "Libraries (823)" 867 "Educational services, n.e.c. (824, 829)" 868 "Not specified educational services" 869 "Museums, art galleries,and zoos (84)" 877 "Religious organizations(866)" 878 "Welfare services (part 867)" 879 "Residential welfare facilities (part 867)" 887 "Nonprofit membership organizations (861-865, 869)" 888 "Engineering and architectural services (891)" 889 "Accounting, auditing, and bookkeeping services (893)" 897 "Miscellaneous professional and related services (892, 899)" 899 "Professional and related services--allocated" 907 "Postal service (part 9190)" 917 "Federal public administration (part 9190, 9490)" 927 "State public administration (9290)" 937 "Local public administration (9390)" ; #delimit cr /* 1983-1991 (Last year & last week) */ if 1983<=`year' & `year'<=1991 { capture gen ind3d_80=. gen ind3d_92=. gen ind3d_03=. gen ind3d_13=. gen ind3d_14=. rename ind ind3d_83 capture gen indly3d_80=. gen indly3d_92=. gen indly3d_03=. gen indly3d_13=. gen indly3d_14=. rename indlyr indly3d_83 } #delimit ; lab def ind3d_83 10 "Agricultural production, crops (01)" 11 "Agricultural production, livestock (02)" 20 "Agricultural services, except horticultural(07, except 078)[83-91]" 21 "Horticultural services (078) [83-91]" 30 "Forestry (08) [83-91]" 31 "Fishing, hunting, and trapping (09) [83-91]" 40 "Metal mining (10)" 41 "Coal mining (11, 12)" 42 "Crude petroleum and natural gas extraction (13) [83-91]" 50 "Nonmetallic mining and quarrying, except fuel (14)" 60 "CONSTRUCTION (15, 16, 17)" 100 "Meat products (201)" 101 "Dairy products (202)" 102 "Canned and preserved fruits and vegetables (203) [83-91]" 110 "Grain mill products (204)" 111 "Bakery products (205)" 112 "Sugar and confectionery products (206)" 120 "Beverage industries (208)" 121 "Miscellaneous food preparations & kindred products (207,209)" 122 "Not specified food industries" 130 "Tobacco manufactures (21)" 131 "not used" 132 "Knitting mills (225)" 140 "Dyeing & finishing textiles, except wool & knit goods (226)" 141 "Floor coverings, except hard surface (227) [83-91]" 142 "Yarn, thread, and fabric mills (228, 221-224)" 150 "Miscellaneous textile mill products (229)" 151 "Apparel and accessories, except knit (231-238)" 152 "Miscellaneous fabricated textile products (239)" 160 "Pulp, paper, and paperboard mills (261-263, 266)" 161 "Miscellaneous paper and pulp products (264)" 162 "Paperboard containers and boxes (265)" 171 "Newspaper publishing and printing (271)" 172 "Printing, publishing, & allied industries, except newspapers (272-279)" 180 "Plastics, synthetics, and resins (282)" 181 "Drugs (283)" 182 "Soaps and cosmetics (284)" 190 "Paints, varnishes, and related products (285)" 191 "Agricultural chemicals (287)" 192 "Industrial and miscellaneous chemicals (281, 286, 289)" 200 "Petroleum refining (291)" 201 "Miscellaneous petroleum and coal products (295, 299)" 210 "Tires and inner tubes (301)" 211 "Other rubber products, and plastics footwear and belting (302-304,306)" 212 "Miscellaneous plastics products (307)" 220 "Leather tanning and finishing (311)" 221 "Footwear, except rubber and plastic (313, 314)" 222 "Leather products, except footwear (315-317, 319)" 230 "Logging (241)" 231 "Sawmills, planning mills, and millwork (242, 243)" 232 "Wood buildings and mobile homes (245)" 241 "Miscellaneous wood products (244, 249)" 242 "Furniture and fixtures (25)" 250 "Glass and glass products (321-323)" 251 "Cement, concrete, gypsum, and plaster products (324, 327)" 252 "Structural clay products (325)" 261 "Pottery and related products (326)" 262 "Miscellaneous nonmetallic mineral & stone products (328,329)" 270 "Blast furnaces, steelworks, rolling & finishing mills (331)" 271 "Iron and steel foundries (332)" 272 "Primary aluminum industries (3334, part 334, 3353-3355,3361)" 280 "Oth.prim.metalind. (3331-3333,3339,pt334,3351,3356,3357,3362,3369,339)" 281 "Cutlery, handtools, and other hardware (342) [83-91]" 282 "Fabricated structural metal products (344)" 290 "Screw machine products (345)" 291 "Metal forgings and stampings (346)" 292 "Ordnance (348)" 300 "Miscellaneous fabricated metal products (341,343,347,349)" 301 "Not specified metal industries" 310 "Engines and turbines (351)" 311 "Farm machinery and equipment (352)" 312 "Construction and material handling machines (353)" 320 "Metalworking machinery (354)" 321 "Office and accounting machines (357, except 3573)" 322 "Electronic computing equipment (3573) [83-91]" 331 "Machinery, except electrical, n.e.c. (355, 356, 358, 359)" 332 "Not specified machinery" 340 "Household appliances (363)" 341 "Radio, T.V., and communication equipment (365, 366)" 342 "Elec.machinery,equip,andsupplies, n.e.c. (361,362,364,367,369)" 350 "Not specified electrical machinery, equipment, & supplies" 351 "Motor vehicles and motor vehicle equipment (371)" 352 "Aircraft and parts (372)" 360 "Ship and boat building and repairing (373)" 361 "Railroad locomotives and equipment (374)" 362 "Guided missiles, space vehicles, and parts (376)" 370 "Cycles and miscellaneous transportation equipment (375, 379)" 371 "Scientific and controlling instruments (381, 382)" 372 "Optical and health services supplies (383, 384, 385) [83-91]" 380 "Photographic equipment and supplies (386)" 381 "Watches, clocks, and clockwork operated devices (387)" 382 "Not specified professional equipment [83-91]" 390 "Toys, amusement, and sporting goods (394)" 391 "Miscellaneous manufacturing industries (39 except 394)" 392 "Not specified manufacturing industries*" 400 "Railroads (40)" 401 "Bus service and urban transit (41 except 412)" 402 "Taxicab service (412)" 410 "Trucking service (421, 423)" 411 "Warehousing and storage (422)" 412 "U.S. Postal Service (43)" 420 "Water transportation (44)" 421 "Air transportation (45)" 422 "Pipe lines, except natural gas (46)" 432 "Services incidental to transportation (47)" 440 "Radio and television broadcasting (483) [83-91]" 441 "Telephone, wire and radio (481) [83-91]" 442 "Telegraph and miscellaneous communication services (482, 489)" 460 "Electric light and power (491) [83-91]" 461 "Gas and steam supply systems (492, 496) [83-91]" 462 "Electric and gas, and other combinations (493) [83-91]" 470 "Water supply and irrigation (494, 497)" 471 "Sanitary services (495)" 472 "Not specified utilities" 500 "Motor vehicles and equipment (501)" 501 "Furniture and home furnishings (502)" 502 "Lumber and construction materials (503)" 510 "Sporting goods, toys, and hobby goods (504) [83-91]" 511 "Metals and minerals, except petroleum (505)" 512 "Electrical goods (506)" 521 "Hardware, plumbing and heating supplies (507)" 522 "Not specified electrical and hardware products [83-91]" 530 "Machinery, equipment, and supplies (508)" 531 "Scrap and waste materials (5093)" 532 "Miscellaneous wholesale, durable goods (5094, 5099)" 540 "Paper and paper products (511)" 541 "Drugs, chemicals, and allied products (512, 516)" 542 "Apparel, fabrics, and notions (513)" 550 "Groceries and related products (514)" 551 "Farm products - raw materials (515)" 552 "Petroleum products (517)" 560 "Alcoholic beverages (518)" 561 "Farm supplies (5191)" 562 "Miscellaneous wholesale, nondurable goods (5194, 5198, 5199)" 571 "Not specified wholesale trade" 580 "Lumber and building material retailing (521, 523)" 581 "Hardware stores (525)" 582 "Retail nurseries and garden stores (526)" 590 "Mobile home dealers (527)" 591 "Department stores (531)" 592 "Variety stores (533)" 600 "Miscellaneous general merchandise stores (539)" 601 "Grocery stores (541)" 602 "Dairy products stores (545)" 610 "Retail bakeries (546)" 611 "Food stores, n.e.c. (542, 543, 544, 549)" 612 "Motor vehicle dealers (551, 552)" 620 "Auto and home supply stores (553)" 621 "Gasoline service stations (554)" 622 "Miscellaneous vehicle dealers (555, 556, 557, 559)" 630 "Apparel and accessory stores, except shoe (56, except 566)[83-91]" 631 "Shoe stores (566) [83-91]" 632 "Furniture and home furnishings stores (571) [83-91]" 640 "Household appliances, TV, and radio stores (572,573) [83-91]" 641 "Eating and drinking places (58)" 642 "Drug stores (591)" 650 "Liquor stores (592)" 651 "Sporting goods, bicycles, and hobby stores (5941,5945,5946)" 652 "Book and stationery stores (5942, 5943)" 660 "Jewelry stores (5944)" 661 "Sewing, needlework, and piece goods stores (5949) [83-91]" 662 "Mail order houses (5961) [83-91]" 670 "Vending machine operators (5962)" 671 "Direct selling establishments (5963)" 672 "Fuel and ice dealers (598) [83-91]" 681 "Retail florists (5992)" 682 "Miscellaneous retail stores (593,5947,5948,5993,5994,5999)" 691 "Not specified retail trade" 700 "Banking (60)" 701 "Savings and loan associations (612) [83-91]" 702 "Credit agencies, n.e.c. (61, except 612)" 710 "Security, commodity brokerage, and investment companies (62,67)" 711 "Insurance (63, 64)" 712 "Real estate, including real estate-insurance-law offices (65,66)[83-91]" 721 "Advertising (731)" 722 "Services to dwellings and other buildings (734)" 730 "Commercial research, development, and testing labs (7391, 7397) [83-91]" 731 "Personnel supply services (736)" 732 "Business management and consulting services (7392) [83-91]" 740 "Computer and data processing services (737) [83-91]" 741 "Detective and protective services (7393) [83-91]" 742 "Business services, n.e.c.(732,733,735,7394,7395,7396,7399)[83-91]" 750 "Automotive services, except repair (751, 752, 754) [83-91]" 751 "Automotive repair shops (753) [83-91]" 752 "Electrical repair shops (762, 7694)" 760 "Miscellaneous repair services (763, 764, 7692, 7699)" 761 "Private households (88)" 762 "Hotels and motels (701)" 770 "Lodging places, except hotels and motels (702, 703, 704)" 771 "Laundry, cleaning, and garment services (721)" 772 "Beauty shops (723)" 780 "Barber shops (724)" 781 "Funeral service and crematories (726)" 782 "Shoe repair shops (725)" 790 "Dressmaking shops (part 729)" 791 "Miscellaneous personal services (722, part 729)" 800 "Theaters and motion pictures (78, 792)" 801 "Bowling alleys, billiard and pool parlors (793) [83-91]" 802 "Miscellaneous entertainment & recreation services (791, 794, 799) [83-91]" 812 "Offices of physicians (801, 803) [83-91]" 820 "Offices of dentists (802) [83-91]" 821 "Offices of chiropractors (8041) [83-91]" 822 "Offices of optometrists (8042) [83-91]" 830 "Offices of health practitioners, n.e.c. (8049) [83-91]" 831 "Hospitals (806)" 832 "Nursing and personal care facilities (805)" 840 "Health services, n.e.c. (807, 808, 809)" 841 "Legal services (81)" 842 "Elementary and secondary schools (821)" 850 "Colleges and universities (822)" 851 "Business, trade, and vocational schools (824) [83-91]" 852 "Libraries (823)" 860 "Educational services, n.e.c. (829)" 861 "Job training and vocational rehabilitation services (833)" 862 "Child day care services (835)" 870 "Residential care facilities, without nursing (836)" 871 "Social services, n.e.c. (832, 839)" 872 "Museums, art galleries, and zoos (84)" 880 "Religious organizations (866)" 881 "Membership organizations (861-865, 869) [83-91]" 882 "Engineering, architectural, and surveying services (891)" 890 "Accounting, auditing, and bookkeeping services (893)" 891 "Noncommercial educational and scientific research (892) [83-91]" 892 "Miscellaneous professional and related services (899) [83-91]" 900 "Executive and legislative offices (911-913)" 901 "General government, n.e.c. (919)" 910 "Justice, public order, and safety (92)" 921 "Public finance, taxation, and monetary policy (93)" 922 "Administration of human resources programs (94)" 930 "Administration of environmental quality & housing programs (95)" 931 "Administration ofeconomic programs (96)" 932 "National securityand international affairs (97)" 991 "Labor force status is unemployed & whose last job was Armed Forces" 992 "Labor force status is unemployed" ; #delimit cr /* 1992 - 2002 (Last year & last week) */ if 1992<=`year' & `year'<=2002 { capture gen ind3d_80=. gen ind3d_83=. gen ind3d_03=. gen ind3d_13=. gen ind3d_14=. rename ind ind3d_92 replace ind3d_92=. if ind3d_92<10 replace ind3d_92=. if 992