|
_________
_________
Queries:
_________
_________
|
| |
How to Construct a Query in the WISH System
A step-by-step example using the Cancer Incidence Module
Within each module of the WISH system, you begin a query by selecting a measure. This selection creates a central data construct from which
additional query options are possible (cancer site, region of residence, and demographic characteristics). In the Cancer Incidence Module you
can focus on any of three measures:
- Number of cancer cases
- Cancer incidence crude rate
- Cancer incidence age-adjusted rate
Next you can select a specific cancer site and further specify query criteria if desired. Submitting a request at this point creates output for
Wisconsin statewide for the most recent year of stored data, giving you a quick, broad view of the data measure you requested. Alternatively, go
to the next section of the query page to select a specific region or county or to choose years or demographic characteristics.
Any time you submit a request, you will first see a pop-up screen that shows what your query will include. The example below is for Lung and
Bronchus cancer.
WISH Query Confirmation
|
Data Set:
|
WISH -- Cancer Module
|
|
Measure:
|
Age-adjusted Cancer Incidence Rate (per 100,000 pop.)
|
|
Cancer Site:
|
Lung and Bronchus
|
|
Geographic Area:
|
Region of Residence
|
|
Years:
|
5 or 10 year Group
|
|
Row Variable:
|
Region of Residence
|
|
Column Variable:
|
|
|
Sex:
|
All
|
|
Race:
|
All
|
|
Ethnicity:
|
All
|
|
Years:
|
2004-2008
|
|
Click OK to obtain the desired output, or choose CANCEL to return to the selection criteria. When the output table is
displayed, you may print it using your browser print features. Here is an example output table for Lung and Bronchus cancer:
|
|
Note:
|
Cell Suppression and Cells with Counts of Zero: An "X" indicates that one or more values within a row or column
is less than 6 (but more than zero) and has been suppressed to protect confidentiality. To obscure the value of the suppressed cell,
some values greater than 5 and corresponding rate or percent values may also be displayed as an "X." A period (.) indicates there are
zero cases in that cell. If all values in a row or column are zero, that row or column is not displayed.
|
|
Start a new query within the same module by clicking NEXT QUERY. Other options shown on an output table include DATA SOURCE, INTERPRETATION,
and HELP. These provide additional information and explanations for reading output from your query. At the end of each option is a BACK
function to return you to the current output table.
RETURN to previous page
Last Revised: March 06, 2013
|
