 |
Answers to Person Selection Problems
Return to Tutorial
How many people included in the Nov 2006 data submission
for the SEER 17 registries have 10 or more tumors? What
is the total number of tumor records for those people?
How many of these tumors are primary tumors?
- 11 individuals in the SEER 17 registries
(Nov 2006 data submission) have 10 or more tumors in the
database.
- The total number of tumor records for these 8 individuals
is 152.
- All 152 are primary tumors. Primary
tumors are tumors that are not recurrences or metastases.
SEER only includes primary tumors in data submissions.
Therefore, all records in SEER databases are primary tumors.
This point is so important that we are saying it here even
though it has nothing to do with Person Selection.
You could have run one Case Listing Session or two Frequency Sessions to get the answers to
these questions.
Using a Case Listing Session
To answer these questions using a Case Listing Session:
- Start a new Case Listing Session.
- Select the "Incidence - SEER 17 Regs Limited-Use, Nov 2006 Sub (1973-2004
varying)" database.
- Turn Person Selection on (Session Menu).
- On the Selection tab, uncheck the Malignant Behavior option in the Select Only box at the top of the page. We want to see all matching tumors, regardless of behavior.
- Click the "Narrow the Selection of Persons" checkbox.
- Set the "Narrow the Selection of Persons" controls to select only persons with a matching
index record and at least 9 additional records.
- Add at least one variable to the table. SEER Registry, Patient ID, Sequence Number, and Site rec with Kaposi and mesothelioma are interesting variables for this exercise.
- Execute the session.
The number of tumor records equals the number of rows in the matrix. The number of individuals is
displayed in the status bar of the matrix window. To verify your results,
open case1.answer1.slm. If you would like to review the settings in
the session, retrieve the session (Matrix menu).
Using Frequency Sessions
Two frequency sessions must be used, one for each question. Frequency sessions are used to
count records based on search criteria and can be used indirectly to provide a count of people. Person
Selection must be turned ON to answer both questions.
Number of People with 10 or More Primary Tumors
- Start a new Frequency Session.
- Select the "Incidence - SEER 17 Regs Limited-Use, Nov
2006 Sub (1973-2004 varying)" database.
- Turn Person Selection on (Session Menu).
- On the Selection tab, uncheck the Malignant Behavior option in the Select Only box at the top of the page. We want to see all matching tumors, regardless of behavior.
- Click the "Narrow the Selection of Persons" checkbox.
- Set the "Narrow the Selection of Persons" controls to select only persons with a matching
index record and at least 9 additional records.
- So that each person is only counted once, set the "For every person, include" drop down list
to "only the index record."
- Execute the session.
- You can look at the results in freq.answer1a.sfm.
Total Number of Tumor Records for Those People
- Use freq.answer1a's session.
- Change the "For every person, include" drop down list
to "all the person's records."
- Execute the session.
- You can look at the results in freq.answer1b.sfm.
|
