Case Listing Selection Tab

The Selection tab is used to select the records to be included in the case listing. If no selection statements are made on the Selection tab, all records in the database will be included. Selection statements reduce the number of records included in a listing based on specific variables in the case data files. In addition, if a multiple primary ready database is selected on the Data tab, you have the option to make selections using each person's tumor history. To enable this feature, open the Session menu and select Person Selection.

Person Selection

In a multiple primary ready database, each record represents a tumor or case, and the records are sorted chronologically. It is possible for a person to have multiple tumors. The Person Selection feature allows you to look at a person's entire tumor history, not just the records that match the tumor subset. To use this feature, open the Session menu and select Person Selection. When a checkmark appears next to this item, it is turned on.

Index Record

Use this box to define the index records. An index record is the first tumor in a person’s history that matches this statement. If this selection is left blank, the person's first record in the database is used as the index record.

Narrow the selection of persons

Use this feature to further subset people in the database. Using a person's first matching record from the above selection as the index record, you can narrow the search using the drop-down list boxes. Select to include only records for people with "at least", "at most", or "exactly", "0"-"99", "additional", "prior", or "subsequent record(s)". To further subset the output, click the Edit button next to the bottom text box, and create selection statements that the additional, prior, or subsequent record(s) must match.

For every selected person, include . . .

When you enable Person Selection for a Case Listing session, all cancers for each qualifying person will be included in the results matrix. You cannot change this. This section of the Case Listing Selection tab appears only for the sake of consistency with Person Selection for a Frequency session.


Suppose you wanted to view the tumor history for people diagnosed first with stomach cancer, followed by colon cancer.

  1. Click the Edit button next to the first text box and create a selection statement for stomach cancer. This will create a subset of all records for those who have at least been diagnosed with stomach cancer.

  2. Check Narrow the Selection of Persons.

  3. From the drop-down list boxes, select "at least", then "1", then "subsequent record(s)".

  4. Click the Edit button next to the bottom Selection box, and create a selection statement for colon cancer.

  5. Make other changes as necessary and execute the session when ready.