GETTING ASSISTANCE EXTRACT Help Lines: (301) 457-4151 457-1210 This program was designed to promote the effective use of data on Census Bureau CD-ROMs. If, after reading this documentation, you have questions about the operation of the program, or have found what appears to you to be an error or "bug" in the program or documentation, you may call Paul Zeisset or Bob Marske of the Census Bureau's Economic Planning Staff at (301) 457-4151. Written correspondence may be directed to the Economic Planning Staff, Bureau of the Census, Washington, D.C. 20233. If you think you have encountered a program bug, first see if you can reproduce the problem. If you call the help line, you may need to be able to tell the person at the other end of the line the precise sequence of steps that brought you to the problem. If the program has terminated abruptly, i.e., "bombed", then EXTRACT leaves a 1-line message at the top of the screen that may be the key to determining the problem. Write the message down precisely (or send it to your printer with ). If you access EXTRACT through a menuing system that takes you back to the menu without giving you time to record any error message, try to run EXTRACT outside the menuing system (i.e., from a C> prompt) or have your menu designer insert a "pause" command after running EXTRACT. That way you can record any error message before calling for help. Among the most common problems that cause program termination is insufficient random access memory (usually a "run error"). EXTRACT requires about 520 kb of RAM under DOS 5 or 6, and network drivers or terminate-and-stay-resident programs may have to be loaded into high memory or removed while you are using EXTRACT. Another problem (usually indicated by a message citing an ".NDX" file) results from the use of EXTRACT under an extra memory manager like QEMM(tm). Type "SET CLIPPER=E000" before running EXTRACT if you encounter that problem. An error message starting "Proc ADDLABVALU" generally indicates that you have attempted to extract a file with a user-defined item not wide enough to accommodate the largest value. It helps to be at your computer when you call the EXTRACT help line. Electronic Bulletin Board System (BBS). You may view the latest bulletins on EXTRACT use, read comments other users have made, and also leave your own questions, comments, or suggestions to other users on data retrieval strategies on the Census Bureau electronic bulletin board under the "CD-ROM" conference. The latest version of EXTRACT and auxiliary files for particular CD-ROMs are available for downloading without charge on the BBS. That board may be reached on (301) 457-2310 (computer). The first time you call, you are asked to complete an on-line registration form. (For voice assistance in logging into the bulletin board, call (301) 457-1242.) In addition to the above mentioned sources, EXTRACT 1.5a was included on 1987 Economic Census CD-ROM 1e, and the latest version will be included on each quarterly 1992 Economic Census CD-ROM. INDEX TO EXTRACT DOCUMENTATION 1987 Economic Census CD-ROMs 35 1990 Census CD-ROMs 39 Aborting EXTRACT with C 34 Adding labels 15 1990 census CD-ROMs 42 Agriculture census CD 36 Advanced Options 23 Advanced topics 24 Agriculture census CD-ROMs 36 Auxiliary files defined 24 for 1990 census STF CD-ROMs 39 Bulletin board for software updates 44 Catalog files, description 24 Catalog selection 5 Color, problems with display 8 Column width 20 Columnar display 18 Selecting from Format Options 17 Comma-delimited extract files 21 Command-line parameters 25 Config.sys 2 Counting number of records selected ("Dry Run") 22 County Business Patterns CD-ROMs 38 County and City Data Book CD-ROM 39 Cursor movement--to top or bottom of file 19 Data dictionary functions 24 Data dictionary, creating a new one 34 DBF extract files 21 Definition display from data display screen 19 from main menu 7 from Select Items 9 from Select Records 12 on 1990 census CD-ROMs 42 Deleting records from an extract file 33 from your MY_FILES catalog 23 Diskettes with EXTRACT software and auxiliary files 44 Display to screen 18 Drive specification 4 Dry run to estimate file size 22 Economic census CD-ROMs 35 Editing an extracted data file 33 your MY_FILES catalog 23 EEO files 39 Electronic bulletin board 44 Error messages 44 Run error 2 Exports and Imports CD-ROMs 38 EXTRACT menu, setting up 25 EXTRACT.PRM 24 Extracting data to a file 21 File manipulation 26 File selection menu first time through 5 second time through 23 Footnote files in census of manufactures 35 Foreign trade CD-ROMs 38 Format Options 17 GO software 39 Headings 17 Headings, 2nd level 14,17 Help screen files 24 Help screens 6 Help via electronic bulletin board 44 Help via telephone 44 Horizontal file merging 28 Indexes creating a new index 27 selecting an existing index 27 Installation of EXTRACT 2 of auxiliary files --see "____READ.ME" files Institute for Electronic Data Analysis, Univ. of Tennessee 44 Jump to a particular... code--Select Records 12 field name--Select Items 9 field name--Add Labels 16 Label files functions 24 looking without linking 33 Labels 15 from more than one file 16 illustration 19 multiple labels from one file 16 Locate a particular description Add Labels 16 Select Items 9 Select Records 12 Lotus 1-2-3 1 importing data into 1-2-3 21 Main menu 7 Manipulate files 26 Margins--printed output 17 Marking a record 19 Master catalog 4 functions 24 as needed for 1988-89 CBP CD-ROM 38 Menus, setting up your own to access different CD-ROMs 25 Merging files 28 MicroSoft Extensions 2 MY_FILES catalog accessing extracted files 23 adding to it 33 editing 23 new entries 22 MY_FILES.cti catalog of indexes 28 PL94-171 39,42 Page length--printed output 17 Percents and similar computations 9 Previewing columnar display 9 Printer settings changing fonts with software 21 margins, headings 17 Printing 21 to a file 22 PRN extract files 21 RAM requirements 2 Ranges, selecting a range of codes 12 Ranking 27 Record selection 10 economic census CDs 35 reinstating previous criteria 14 showing criteria in effect 8 strategies 12 RECTYPE 13 Restricting session to files for a State 5 Rowwise display 20 selecting from Format Options 17 Run error 2,44 Saving format options 23 Saving parameters 4,25 SDF extract files 21 Secondary files display 33 Select Items 8 on 1990 census CD-ROMs 41 Select Records 10 on 1990 census CD-ROMs 41 on agriculture census CD 36 reinstating previous criteria 14 with conditional clauses 32 Sequence of items in display 30 Showing full contents of truncated column 19 record selection criteria 8 Sorting (creating a new index) 27 Speed of execution 18 Speed-up-retrieval prompt 13 STFs 1A, 1B, 1C, 3A, 3B, and 3C 39 Storage requirements of extract files 22 SUMLEV 13,41 Toggling between columnar and rowwise display 20 Totals across multiple records 31 of items in the same record 9 Tutorials 1 USA Counties CD-ROM 39 User-defined items 9 Vertical file merging 30 Width of column 20 in Preview mode 9 Word search in Add Labels 16 in Select Items 9 in Select Records 12 Work directory creation 2 as default location for extracted files 22