BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Marjolein
Obsidian | Level 7

Hi all,

 

 

I'm interested in knowing whether the individual levels of my row variable are related to my column variable in a contingency table.

Is SAS able to produce Chi-square tests for each row of your contingency table, in stead of a general chi-square test? I cannot seem to work out how to do it.

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

If you want test " each level of SES" , that mean these three row level is independent. That make "association" nonsense.

if column level from first to last ,  what gonna do with the single row level ?  You can ONLY measure "association" between two variables which have more than two levels .

 

You can try Trend Analysis ,but that is only for 2xn or nx2 contingency table.

 

Example 40.8: Cochran-Armitage Trend Test 

View solution in original post

6 REPLIES 6
ballardw
Super User

You should provide a brief example of your data (variable names help the discussion) and the say which are needed for your test. Since chi-sq also wants count values you will need to indicate which are the category values and which are the counts for those values.

Often data needs to be reshaped before some tests.

Marjolein
Obsidian | Level 7

OK, I understand! 🙂

 

For example: I have my row variable SES, with the levels low, moderate and high. I want to test, whether each level of SES is associated with physical activity which has been divided in four categories (no, moderate, active, severe). What I want to get out is 3 p-values, each indicating whether the level of SES (low, moderate and high) is associated with the level of physical activity.

I know that Chi-square generally tells you whether the two variables are associated, but can you also ask for row-specific tests?

 

Am I making myself more clear now? 🙂 I hope so. Please let me know if not.

 

 

Ksharp
Super User

If you want test " each level of SES" , that mean these three row level is independent. That make "association" nonsense.

if column level from first to last ,  what gonna do with the single row level ?  You can ONLY measure "association" between two variables which have more than two levels .

 

You can try Trend Analysis ,but that is only for 2xn or nx2 contingency table.

 

Example 40.8: Cochran-Armitage Trend Test 

Marjolein
Obsidian | Level 7

OK I see, thank you!

Ksharp
Super User

You mean One-Way Chi-square ?

 

proc freq data=sashelp.class;
where age=14;
table sex/ testp=(0.5 0.5); *testf=(10 6);
run;
Marjolein
Obsidian | Level 7

Not quite, see my more clear explanation above: I have two categorical variables, but I don't want to know whether they are related in general, but I want to see whether each level of my row variable (SES: low, moderate, high) is associated with my column variable (physical acitivy: four levels). So I want three P-values: each indicating whether the level of SES is associated with physical acitivity.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 2161 views
  • 0 likes
  • 3 in conversation