Each type of SEER*Stat session has a Data tab, on which you select a database to use in your analysis. Highlight a database to select it.
Always select the database first. The correct database must be selected from the Database table in order to see the correct list of variables throughout the session, including in selection statements, on the Table tab, and in the dictionary. The databases listed on the Data tab are those in your active data locations, excluding any that are inappropriate for the type of session you selected. Note: If you cannot find an appropriate database for your analysis in the list of available databases you can edit your active data locations in Preferences.
After selecting a database, you may find it helpful to work through the remaining tabs in order from left to right, and to work from top to bottom on each tab. This will help to ensure that you make all necessary selections.
A suggested citation for the highlighted database is displayed at the bottom of the Data tab. When you highlight a different database, the citation will be updated accordingly.
See Using Your Own Data to learn how to create new SEER*Stat databases from text data files.
Depending on the type of session, the Database table, has three or four columns containing information about each database available to you. You can sort the table by clicking on the column headers for "Database Name" or "Linked To" to sort the list alphabetically according to the contents of that column.
Some databases are "linked to" other files that contain additional information about the records in the database. They are linked to these files by means of the variables listed in the "Linked By" column, which function like a relate key in a relational database: SEER*Stat matches each record in the original database with the record in the linked file that has the same values for those variables. Thus, the linked file can add many more fields to the records in the original database, avoiding the need to explicitly incorporate that data into each database that uses it. The linked files are themselves databases, and can be viewed in a Case Listing session.
Database Name - The name of each database provides you with information about the type of data it contains and the type of analysis for which it should be used.
Linked To - This column contains the name of the file to which this database is linked.
Linked By - This column contains the name of the variable(s) shared by this database and the linked file.
Pop Variables (Rate and LD Prevalence sessions) - This column lists the names of each population variable used in the database.
Under the Database table are three buttons and a link.
The Find button opens the Find Database dialog that allows you to search the text by keying letters or numbers into the Search Text field. Once you have four or more characters in the text field only those databases which have those characters are in the table. Select a database from the list and click the OK button. The Find Database dialog closes and the database you selected is selected on the Data tab.
The Original Sort Order button restores the database to the original order if you have sorted by one of the sortable columns. Note: The original sort order is by database types and the number of SEER registries included in the data.
The Change Linked Database button becomes active when you open or retrieve a session that was created with a linked database that does not exist in any of your active data locations. Note: Sometimes the database that was used in the original session has been updated and has a slightly different name. Click on the button to open a dialog where you can change the link to another database.
The View More Database Details link appears next to the buttons whenever you select a database where there are more details available. When you click on the link it opens a page on the National Cancer Institute web site where SEER database information can be found.