How to Search The 1992 Economic Census CD ROMs The Economic Census provides a picture of the Nation's economy every five years. It details industry information for geographic areas ranging from the entire US, to States, cities, and ZIP codes. The Report Series CD ROM contains information from all economic sectors for geographic areas ranging from the entire US, to individual states, to cities. Nonemployer Statistics are mainly composed of sole proprietorship businesses, though a small percentage of partnerships and corporate entities are included. The numbers are derived from IRS information. However, because their coding scheme is not as detailed as the SIC Codes, data for nonemployers is reported at a broader level that the rest of the Economic Census. The ZIP Code CD reports information about retail, manufactures, and service industries by ZIP code. Searching differs from the other Economic Census CDs, and is in a separate section in this guide. The economic sector data is displayed by the Standard Industrial Classification (SIC) number. A Manual, which contains the entire scheme, is available on Reference Table 5A in the Government Documents Service area (PrEx 2.6/2:In 27/987). (Computer Screen) ЩЭЭЭЭЭЭЭЭЭбЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЕ 1992 Economic Census ЦЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЛ К Г К К Г К К Г К К Г К К Г К К Г К ЧФФФФФФФФФСФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФФЖ К К К Retail Trade К К Wholesale Trade К К Service Industries: Firms Subject to Federal Income Tax К К Service Industries: Firms Exempt from Federal Income Tax К К Transportation, Communications and Utilities К К Financial, Insurance and Real Estate Industries К К Manufactures К К Mineral Industries К К Construction Industries К К Minority- and Women-Owned Business К К Enterprise Statistics К К К К К К К ШЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭЭМ Џ-Move Enter-Select Sector Esc-Exit End-Quit Arizona State University University Libraries How to Search (Report Series and Nonemployer CDs) The 1992 Economic Census is searched through a series of menus. Highlight the desired choice using the up and down arrow keys and select it by pressing . To backtrack, press the Escape key, . A menu of options is available on the bottom line of each screen. 1.Using the up and down arrow keys, select an economic sector and press . * If necessary, select additional options. * You can only select the highlighted menu options. 2.Select a geographic summary level using the arrow keys and press . How to Search (ZIP Codes) The 1992 Economic Census is searched through a series of menus. Highlight the desired choice using the up and down arrow keys and select it by pressing . To backtrack, press the Escape key, . A menu of options is available on the bottom line of each screen. 1. Using the up and down arrow keys, select an economic sector and press . * You can only select the highlighted menu options. (How to Search [Zip Codes] Cont.) 2. Select a state using the arrow keys and press . * Typing the first letter of a word moves the cursor to that letter. 3. Press f (find) to select a specific ZIP code or place. * A menu opens at the top of the screen. Entering numbers searches by ZIP code, while letters searches by place. 4. Press the for activity by SIC number in a ZIP code. Displaying Data (ZIP Codes) All Industries in a Single Area The default display is for all businesses (by SIC code) in a single ZIP code. * Menu options allow you to display industries by size of receipts (r) or by the number of employment (e). Single Industry in Multiple Areas The "browse" option will display a single industry for multiple areas. 1. Highlight an SIC Number. 2. Type B (Browse). * A table comes up displaying the same columns as the previous table, but for a single SIC code in multiple ZIP codes. 3. Press S (Sort). 4. Highlight the column by which you want to sort and press . Printing Census Data (All Economic Census CDs) When the data is displayed: 1. Type P (Print). 2. Select "Print table to printer" and press . Downloading Data to your Floppy Disk (All Economic Census CDs) For a general overview on downloading from Governmental CD ROMs, see the section in this manual on downloading. Text files can be loaded into a word processing program such as Word Perfect. However, you may have to widen the margins before uploading the data. The program will not warn you if the file name already exists on your floppy, but, it will write over that information. Make sure you give each file a different name. Also, make sure to specify the drive letter where you inserted the floppy. Example: a:data1, a:data2, etc. (Downloading Cont.) Text Files 1. Type P (Print). 2. Select "Print table to file" and press . 3. Type the name of the file. * The program automatically supplies the DOS extension PRN. Copyfile This option allows you to download all the information printed in the paper reports including information not displayed on the screen. The data can then be loaded into a spreadsheet or database program. Geographic areas are listed by their Federal Information Processing Standards (FIPS) number, not their name. Those codes are listed in Guideline: codes for named populated places, primary county divisions, and other locational entities of the United States and outlying areas (C 13.52:55-2/guide, Ref. Table 5A). Use this source to translate the code to the place name. Industries (excluding those in the construction and manufactures sectors) are identified by a Census code, not by the SIC number. Copy the "Type of Business" code from the back of this section. Construction and Manufacturers are identified by their SIC code. See part 2 of the SIC Manual ("Numerical List of Short Titles" - p.423) for a brief listing of those economic sectors. 1. Select C (Copyfile). 2. Press the to continue. 3. Select Format and press . * See format options below. 4. Type the file name and press . 5. At the "Create technical documentation" prompt select Yes. * The technical documentation is the guide to what information was copied in each column. * The program will supply the DOS extension .DOC. 6. Press any key to continue. Format Options ASCII (flat/SDF): This option downloads the contents as an ASCII columnar file with each data element in separate columns and adds ".TXT" as the DOS extension. ASCII (delimited): This option downloads the information as an ASCII comma delimited file with commas between each data element and adds ".DEL" as the DOS extension. (Format Options Cont.) Lotus (spreadsheet): This option downloads the data in Lotus 2.x and higher format and adds .WK1" as the DOS extension. dBASE: This option downloads the data in dBASE format and adds ".DBF" as the DOS extension. Geographic Definitions Metropolitan Statistical Areas (MSA): Before the 1990 Census these were known as Standard Metropolitan Statistical Areas (SMSA). They have a large population nucleus and nearby communities which have a high degree of economic and social integration. MSAs include the city, its urbanized area, and the remainder of the county or counties in which it is located. Place: These can either be incorporated areas, i.e., Tempe, Tucson, or an unincorporated "Census Designated Place." prepared by Kenneth Furuta, Arizona State University. 1992 Economic Census 1992 Economic Census