How can I generate a table showing all reference categories?

[khalidamin]

See the attached file. Thank you in advance.

[Reeza]

Not sure what your question is, I see output from proc logistic...

[khalidamin]

I want to generate a table as shown is the attached file using SAS

[Reeza]

But the point estimate isn't 1, it's 0.

[khalidamin]

Oh yes, it’s zero. Sorry for the typo.
Is there any option in proc logistic to display reference category?

[Reeza]

Not as far as I know, you'll have to manually add those rows in, especially as the reference level can vary depending on the code so there's not an easy way to automate that ... at least that I can think of at the moment.

[khalidamin]

Thanks Reeza for your time - I really appreciate.

[FreelanceReinh]

Hello @khalidamin,

If you just need a dataset containing class variable names and their reference categories (which you could then "interleave" with an odds ratio table where the reference categories are omitted), you can use the ClassLevelInfo ODS output dataset:

ods output ClassLevelInfo=cli;
proc logistic ...;
...
run;

data reflevels(keep=clvar value);
set cli;
if class ne ' ' then clvar=class;
if max(of x:)=0;
retain clvar;
run;

Alternatively, you could start with the OddsRatios ODS output dataset. But unfortunately variable Effect in this dataset contains concatenated strings like 'gender    1 vs 0' so that you would need to work with character functions such as SCAN to extract variable names and values. This might become difficult in general, e.g., if values (or even variable names) contain blanks or the substring "vs", etc.