Topic6DataAnalysis (TableAnalysis)
Uploaded by
Dung NhatTopic6DataAnalysis (TableAnalysis)
Uploaded by
Dung NhatData Analysis
Topic 6 Topics to be covered:
Analysis using Table Analysis
Independent and Dependent variables
Row and Column percentages
Group Analysis By (Control Variable)
Data Analysis
Prepared by [Link] 2
Table Analysis Table Analysis
Import [Link] into SAS
Generates output in tabular format Tasks Describe Table Analysis…
Assign all categorical variables (SATJOB, INCOME4) to
Analyzes relationships between any two the table variables task role
categorical variables
Appropriate for variables with a limited no.
of categories
Crosstabs in PSPP is similar to Table
Analysis in SAS
Prepared by [Link] 3 Prepared by [Link] 4
Table Analysis Table Analysis
Select Tables from the selection pane and drag variables Select Cell Statistics from the selection pane and check
from Variables permitted in table to Preview either in Cell frequencies and click Run
row or column (SATJOB in row and INCOME4 in column)
Prepared by [Link] 5 Prepared by [Link] 6
Table Analysis Table Analysis
Marginal Row Total: a total no. of cases
based on one category of the dependent
variable
Marginal Column Total: a total no. of
cases based on one category of the
independent variable
Grand Total: a total no. of valid cases
Grand total
Marginal column total Frequency: a total no. of cases which
Marginal row total data are collected for both variables
Prepared by [Link] 7 Prepared by [Link] 8
Table Analysis Table Analysis
Modify task
The result will be shown as below
Select Cell Statistics from the selection pane and check
Row percentages, Column percentages and Cell
frequencies
Note:
Row percentages : percentage of frequency based on marginal row
total
Column percentages : percentage of frequency based on marginal
column total
Total percentage : percentage of frequency based on grand total
Prepared by [Link] 9 Prepared by [Link] 10
Table Analysis Table Analysis
Which of the following statements is correct? When deciding which variable should be in row
49.33% of the 60000+ income earners are Very satisfied and which one in column, determine dependent
49.33% of the Very satisfied respondents earn 60000+ variable and independent variable
Independent variable is listed in column; and
dependent variable in row (e.g. job satisfaction
depends on income)
If you put more than one variable in the row or
column, SAS will display a separate table for each
combination of row and column variables. This is
called control variable.
Prepared by [Link] 11 Prepared by [Link] 12
Table Analysis Table Analysis
The result will be shown as below
Modify task
Select variable Sex (control variable) and drag it
under Group analysis by
Run
Prepared by [Link] 13 Prepared by [Link] 14
Practice Workshop 10
Use data set sports.sas7bdat and find the answers
Use data set sports.sas7bdat
to these questions.
How many percent of Mail orders are for 1. How many percent of Mail orders (channel) are
Soccer ball? for Soccer ball (item_name)?
How many percent of Accessories are 2. How many percent of Accessories (category)
purchased through Web? are purchased through Web (channel)?
How many percent of Web sales are for 3. How many percent of Web sales (channel) are
Accessories? for Accessories (category)?
Save all results in SAS E-Guide project (*.egp) and
write down your answers in MS Word (*docx).
Prepared by [Link] 15 Prepared by [Link] 16