readme.gsp Data group: gsp Description: Gross State Product by Industry, 1963-1992. (Splices together the 1963-1986 and 1977-1992 data into one continuous series.) Data Source: Bureau of Economic Analysis, 2 separate series Comments: An extra SAS format file is included for this series, called indus.varfmt It has SAS formats to map the SIC industry codes to descriptions. Usage: To look up values of these data for a set of key variable values (in SAS): a) In your SAS program, before your data step add: %include 'gsp.fmt'; b) set SUPERKEY to the combination of key variable values you want to look up. See "SUPERKEY=" under key variable description below. Key vars: STATE = FIPS state code, 99=US total YEAR = 4-digit year of data INDUS = SIC industry code Varname Typ Description STATE Num STATE (FIPS) Min=1 Max=99 YEAR Num YEAR Min=1963 Max=1992 INDUS Num Industry code (SIC) Min=0 Max=113000 see indus.varfmt, and "Additional documentation", below SAS code to make SUPERKEY: SUPERKEY =(100000000*YEAR) + (1000000*STATE) + INDUS; Data series [summary]: Varname Fmtname Typ Description ------- ------- --- ----------- GSPCURD GSPCURD. Num Gross State Product in current $ GSP87D GSP87D. Num Gross State Product in constant 87 $ ---------------------------- Data series GSPCURD ---------------------------- Varname Fmtname Typ Description GSPCURD GSPCURD. Num Gross State Product in current $ Units=millions of (current) $ Min=-210 Max=5,994,063 Mean=5335.17 N=113,880 N_Missing=0 How missings handled: missings were treated as zeros Comments: for Industry codes, see indus.varfmt and "Additional Documentation" below Usage: MYVAR=put(SUPERKEY,GSPCURD.); ---------------------------- Data series GSP87D ---------------------------- Varname Fmtname Typ Description GSP87D GSP87D. Num Gross State Product in constant 87 $ Units=millions Min=-1473 Max=5,001,445 Mean=7342.34 N=113,880 N_Missing=0 How missings handled: missings were treated as zeros Comments: for Industry codes, see indus.varfmt and "Additional Documentation" below Usage: myvar=put(superkey,GSP87D.); Additional Documentation: SIC industry codes CODE Description ---- ----------- 0 TOTAL 5000 PRIVATE INDUSTRIES 10000 AGRICULTURE, FORESTRY, AND FISHERIES 10010 FARMS 20070 AGRICULTURL SVCS, FORESTRY AND FISHERIES 30000 MINING 30100 METAL MINING 30120 COAL MINING 30130 OIL AND GAS EXTRACTION 30140 NONMETALLIC MINERALS, EXCEPT FUELS 40000 CONSTRUCTION 50000 MANUFACTURING 51000 DURABLE GOODS 51240 LUMBER AND WOOD PRODUCTS 51250 FURNITURE AND FIXTURES 51320 STONE, CLAY, AND GLASS PRODUCTS 51330 PRIMARY METAL INDUSTRIES 51340 FABRICATED METAL PRODUCTS 51350 INDUSTRIAL MACHINERY AND EQUIPMENT 51360 ELECTRONIC AND OTHER ELECTRIC EQUIPMENT 51371 MOTOR VEHICLES AND EQUIPMENT 51379 OTHER TRANSPORTATION EQUIPMENT 51380 INSTRUMENTS AND RELATED PRODUCTS 51390 MISCELLANEOUS MANUFACTURING INDUSTRIES 52000 NONDURABLE GOODS 52200 FOOD AND KINDRED PRODUCTS 52210 TOBACCO MANUFACTURES 52220 TEXTILE MILL PRODUCTS 52230 APPAREL AND OTHER TEXTILE PRODUCTS 52260 PAPER AND ALLIED PRODUCTS 52270 PRINTING AND PUBLISHING 52280 CHEMICALS AND ALLIED PRODUCTS 52290 PETROLEUM AND COAL PRODUCTS 52300 RUBBER AND MISC PLASTIC PRODUCTS 52310 LEATHER AND LEATHER PRODUCTS 60000 TRANSP, COMMUNICATION, AND PUBLIC UTIL 62000 TRANSPORTATION 62400 RAILROAD TRANSPORTATION 62410 LOCAL AND INTERURBAN PASSENGER TRANSIT 62420 TRUCKING AND WAREHOUSING 62440 WATER TRANSPORTATION 62450 TRANSPORTATION BY AIR 62460 PIPELINES, EXCEPT NATURAL GAS 62470 TRANSPORTATION SERVICES 64000 COMMUNICATION 66000 ELECTRIC, GAS, AND SANITARY SERVICES 70000 WHOLESALE TRADE 80000 RETAIL TRADE 90000 FINANCE, INSURANCE, AND REAL ESTATE 90600 DEPOSITORY INSTITUTIONS 90610 NONDEPOSITORY INSTITUTIONS 90620 HOLDING COS. AND INVESTMENT SERVICES 90630 INSURANCE CARRIERS 90640 INSURANCE AGENTS, BROKERS, AND SERVICES 90650 REAL ESTATE 100000 SERVICES 100700 HOTELS AND OTHER LODGING PLACES 100720 PERSONAL SERVICES 100730 BUSINESS SERVICES 100750 AUTO REPAIR, SERVICES, AND GARAGES 100760 MISCELLANEOUS REPAIR SERVICES 100780 MOTION PICTURES 100790 AMUSEMENT AND RECREATION SERVICES 100800 HEALTH SERVICES 100810 LEGAL SERVICES 100820 EDUCATIONAL SERVICES 100830 SOCIAL SVCS AND MEMBERSHIP ORGANIZATIONS 100840 OTHER SERVICES 100880 PRIVATE HOUSEHOLDS 110000 GOVERNMENT 111000 FEDERAL CIVILIAN GOVERNMENT 112000 FEDERAL MILITARY GOVERNMENT 113000 STATE AND LOCAL GOVERNMENT -----------------------contents of SAS data set--------------------------- CONTENTS PROCEDURE Data Set Name: GSP Observations: 113880 Member Type: DATA Variables: 6 Engine: V611 Indexes: 0 Created: 9:59 Monday, November 4, 1996 Observation Length: 42 Last Modified: 10:00 Monday, November 4, 1996 Deleted Observations: 0 Protection: Compressed: NO Data Set Type: Sorted: YES Label: -----Engine/Host Dependent Information----- Data Set Page Size: 8192 Number of Data Set Pages: 588 File Format: 607 First Data Page: 1 Max Obs per Page: 194 Obs in First Data Page: 168 File Name: /pazza/b/GSP/gsp.ssd01 Inode Number: 116745 Access Permission: rw-rw-r-- Owner Name: carola File Size (bytes): 4825088 -----Alphabetic List of Variables and Attributes----- # Variable Type Len Pos Label --------------------------------------------------------------------------- 4 GSP87D Num 8 24 Gross State Product in constant 87 $ 5 GSPCURD Num 8 32 Gross State Product in current $ 3 INDUS Num 8 16 Industry code (SIC) 2 STATE Num 8 8 State (FIPS) 6 ST_CHAR Char 2 40 1 YEAR Num 8 0 Year -----Sort Information----- Sortedby: STATE YEAR INDUS Validated: YES Character Set: ASCII