SCDHEC Home page










CEH Award

SCAN Mothers Health Tables


See an Example of a Mother's Health and Lifestyle Table, Trendline, and Bar Chart

Example of a Table

SCAN users should ask themselves, "What question am I trying to answer?" or "What am I researching?" Answering these questions will help the user to determine which variables should be selected during each step of the table creation process.

For this example, we were interested in seeing South Carolina's Health and Lifestyle Indicators by race breakdown and rates for the year 2001. In order to generate the above table that answers our research interests, the following step-by-step process was followed on the "Create a Table" page.

STEP 1
Step One defines the variable whose levels will occupy the rows of the table. Users can select year, race, ethnicity, age, marital status, region, or lifestyle and health indicators. For this example, lifestyle and health indicators was chosen.
STEP 2
Step Two defines the variable whose levels will occupy the columns of the table. Users can select year, race, ethnicity, age, marital status, region, or lifestyle and health indicators. For this example, Year was chosen.
STEP 3
Step Three specifies the years of interest. If year is the chosen row or column variable, the years you select in this step will occupy the rows or columns of your table. If year is neither a row nor column variable in your table, all years selected in this step will be summed together and shown in your table. For this example, we selected year 2002 - 2005.
STEP 4
Step Four is an optional step. In this example, we did not make any specifications here. If we were interested in seeing this same information for a particular combination of race, ethnicity, age, and marital status, this is the step where those levels would be defined.
STEP 5
Step Five specifies the output level for the table. Users can select zip codes, counties or DHEC regions. If zip codes are chosen no rates will be available due to the population data being limited to counties. For our example, we selected counties.
STEP 6
Step Six defines the geographic area to tally for your table. Users can select the entire state, a single county, or any group of counties. If trendline or bar charts are desired, users may select up to 15 regions.
To select a county simply click on the chosen county in the "Regions" box and then use the down arrow button so that the selected counties move to the "Selected Regions" box, or double click on the chosen county. Multiple regions can be selected only when region is chosen as a row or column variable. For this example, we selected Charleston County and removed the default of "All Counties in South Carolina".
STEP 7
Step Seven specifies particular Health and Lifestyle Indicator of Interest. If "Health and Lifestyle indicators" is chosen in either Step One or Step Two, then multiple health and lifestyle indicators can be selected here. Otherwise, only one health and lifestyle indicator can be selected at a time in this step. For our example, we were interested in Live Births, Electronic Fetal Monitoring, Ultrasound, Induction, Stimulation, Tocolysis and Amniocentesis.
STEP 8
Step Eight specifies the numeric output for the table. Users can select from frequencies only, frequencies and percent, and frequency and rates. 95% confidence intervals can also be selected only when frequency and rates is selected. For this example, only Frequencies and Rates was selected.
STEP 9
Step Nine allows the user to select the output presentation format. The user can select any of the listed options: Table, Trendline and/or Bar Chart (Table is always generated) Some options will not be appropriate depending on the variables that users have selected in the previous steps. For this example Table trendline and Bar Chart was selected.
SUBMIT REQUEST
Submit the request after completing the step-by-step process. An output table will be promptly returned to the user based upon the specifications. Once the table is returned, the user can view, print, or download the table. The rotate option on the table allows the row and column variables to rotate. All specifications from the step-by-step process are defined in the table's title and labeling. Double-check this information to make sure you've obtained the information to answer your research objective.
TRENDLINE AND BAR CHART
In order to generate a Trendline the user must select Year as a column variable in step 2, and must also select consecutive years in step 3. Below is the screenshots of trendline and bar chart from the same example as above.
Example of Trendline
Example of a Bar chart

INTERPRETATION OF DATA
Interpretation of the table is the user's responsibility. Thorough labels are provided to make interpretation more intuitive. For this example, in Charleston County in 2002 there were 4,536 total births, a rate of 14.3 per 1000 people residing in Charleston County. The rate being interpreted as: Out of 1000 live births in 2002, 710.3 of them had electric fetal monitoring performed. There are no data for Electronic Fetal Monitoring, Ultrasound, Stimulation and Amniocentesis starting year 2004 because these information is not included in the new revised birth certificate.
WHEN USING THE TABLE
Please reference any data extracted from the SCAN system as follows: Source: Division of Biostatistics, PHSIS, SC DHEC.

SC Home  |  SC DHEC  |  PHSIS  |  SCAN  |  MICA  |  Contact Us


Document's URL:
Page Maintained by SCAN Project Team
Last updated by the Division of Biostatistics and Health GISPHSIS, of SCDHEC. DISCLAIMER