Centers for Disease Control and Prevention


About N C H S graphic and link
InformaciĆ³n en EspaƱol
Fastats A-Z provides health statistics and links to additional sources of information
N C H S help graphic and link
Coming Events graphic and link
Surveys and Data Collection Systems graphic and link
National Health and Nutrition Examination Survey graphic and link
National Health Care Survey graphic and link
National Health Interview Survey graphic and link
National Immunization Survey graphic and link
Longitudinal Studies of Aging (LSOAs)
National Survey of Family Growth graphic and link
State and Local Area Integrated Telephone Survey graphic and link
National Vital Statistics System graphic and link
Initiatives graphic and link
Aging Activities graphic and link
Disease Classification graphic and link
Healthy People graphic and link
Injury graphic and link
Research and Development graphic and link
Research Data Center
NCHS Press Room
News Releases graphic and link
Publications and Information Products graphic and link
Statistical Export and Tabulation System
Listserv graphic and link
Graphic and link to FEDSTATS and other sites
Download graphic
Adobe Acrobat Reader graphic and link
PowerPoint Viewer 2003 graphic and link
National Center for Health Statistics 3311 Toledo Road Hyattsville, Maryland 20782
Toll Free Data Inquiries 1-800-232-4636

CDC Home Search Health Topics A-Z
nchshd.jpg (16250 bytes)

 

Selecting Records

Selecting records allows you to select a subset of records for tabulating or exporting data. If subsetting is necessary, it must be completed before making a table.

1. At the opening menu, click the + sign to the left of the Data folder. Names of data files drop down. Click on a file name>Tabulate data. This command will provide you with an empty spreadsheet to build a table.
2.Select Records
>Select.
3. Click Assist
4. To select from the field list, type in the field name or left-click twice to display the list and select the appropriate field names.
5. To select from the code list, type in the code value or left-click twice. For instance, if you want to select a subset of women, double-click on the sex field under the field list and the code for female under the code list.Selecting records screen image

You may select from the following operators:

bullet graphic=  equal to

bullet graphic!= not equal to

bullet graphic>  greater than

bullet graphic<  less than

bullet graphic>=greater than or equal to

bullet graphic<=less than or equal to

bullet graphic: in ("in" operators are used to collect records in or not in an interval)

bullet graphic!: not in

6. If you have more than one criteria for the subset, make sure to chose the appropriate connector. 
7. For a list of the total records found matching the criteria selected, click Refresh.
8. Click Accept
9. Click Select to collect the records of the subset. (Once records have been selected, you may change your selection by choosing Records
> Clear. To select new records, you must repeat the records selection process.)

bullet graphicThe system will not retain a selected subset. Changing to a different option (such as from Tabulate to Export) will clear the selected subset.

bullet graphicTo retain the subset for further use, save the expression to the hard drive before selecting the records. The subset expression can be loaded at a later time for use with another option.

 

This page last reviewed January 11, 2007

H H S Health and Human Services logo and link
U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES
Centers for Disease Control and Prevention
National Center for Health Statistics
Hyattsville, MD
20782

1-800-232-4636