Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- Analytics
- /
- Stat Procs
- /
- Hi all, I am trying to determine if there is an association between a...

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

☑ This topic is **solved**.
Need further help from the community? Please
sign in and ask a **new** question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 04-30-2022 04:51 PM
(757 views)

Hi all,

I am trying to determine if there is an association between a categorical but not ordered predictor variable (occupation) and a categorical ordered outcome variable (relatedness). Which are assigned the following levels:

Occupation - 0 = farmer, 1 = fisher, 2 = baker

Relatedness - 0 = low, 1 = medium, 2 = high

I am trying to perform the regression using the following code:

proc logistic data = mydata; class occupation(ref = '0') relatedness(ref = '0'); model relatedness = occupation; run;

The model is converging and the score test for the proportional odds assumption is not significant. I am however a bit confused about how to interpret the odds ratio estimates from the output. I have zero or the farmer occupation as the reference and the reported OR compared to fishers is 0.672 and the OR compared to bakers is 1.189. Is this OR the same over the low, medium, and high levels of relatedness or am I off base? Any help would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

5 REPLIES 5

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Ok, that makes sense. Thank you. How then would I obtain the odds ratios for medium and higher relatedness?

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

That question is not consistent with an ordinal response. As discussed in this note, the model on an ordinal response models a set of logits, each of which divides the set of response levels into two groups. This is done by moving the division between the ordered levels progressively higher. What you seem to want is to contrast a pair of response levels (2 and 1), not involving the other level (0). If that is what you want, then you want a nominal, not an ordinal, model. That requires specifying the LINK=GLOGIT option in the MODEL statement. If the DESCENDING option is used, then the first logit defined will contrast response level 2 with response level 1, and the second logit will contrast level 2 with level 0. So, the odds ratio on the first logit would be what you want. In summary:

```
proc logistic;
class occupation(ref="0");
model relatedness(desc) = occupation / link=glogit;
run;
```

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Ok, that makes sense. Thanks so much!

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

If you want check association between two categorical variable, try using Chi-Square Test in PROC FREQ.

proc freq data=.......;

table relatedness* occupation/chisq;

run;

if one of them is ordered category variable check CMH test in PROC FREQ.

proc freq data=.......;

table relatedness* occupation/cmh;

run;

proc freq data=.......;

table relatedness* occupation/chisq;

run;

if one of them is ordered category variable check CMH test in PROC FREQ.

proc freq data=.......;

table relatedness* occupation/cmh;

run;

Are you ready for the spotlight? We're accepting content ideas for **SAS Innovate 2025** to be held May 6-9 in Orlando, FL. The call is **open **until September 25. Read more here about **why** you should contribute and **what is in it** for you!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.