BookmarkSubscribeRSS Feed
sierranalani
Calcite | Level 5

I'm computing a Logistic regression to get RRs. I have a combination of binary and categorical variables.  My output current gives me beta estimates for the binary variables accurately, however it gives me only one Beta estimate for the categorical variable and it seems as though it is treating them as binary variables. For my main categorical variable county designation it has three levels (Urban, Rural, Frontier). Here is my code:

PROC GENMOD DATA= Test DESCENDING;
	CLASS CntyDes (ref = 'Urban') / param = ref;
	MODEL UTD (event = 'Yes') = CntyDes / dist = bin link = log;
	ESTIMATE 'BetaFrontier' CntyDes 1 / exp;
	RUN;

Contrast Estimate ResultsLabel Mean Estimate Mean L'Beta Estimate StandardError Alpha L'Beta Chi-Square Pr > ChiSqConfidence Limits Confidence LimitsBetaFrontierExp(BetaFrontier)

0.68740.50990.9266-0.37490.15240.05-0.6735-0.07626.050.0139
   0.68740.10470.050.50990.9266 

The contrast estimate results give me the beta estimate of the Frontier designation but nothing for the Rural one. Is there a way to add the rural designation to the estimate statement or even just have the rural one come up in the Beta output instead of the Frontier one?

3 REPLIES 3
PaigeMiller
Diamond | Level 26

Your output is impossible to read as presented. Can you present the output in readable fashion? (screen capture is okay)

--
Paige Miller
PaigeMiller
Diamond | Level 26

The MODEL statement should show that there are estimates for all levels of CNTYDES . Since you are getting a estimate for just Frontier, I am guessing that there is missing data in your data set for the other levels. Please check to make sure the other levels appear in your data set, and that UTD is not missing for each of the other levels. Also please check the log for ERRORs or WARNINGs about missing data.

--
Paige Miller

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 3 replies
  • 512 views
  • 1 like
  • 2 in conversation