BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
AlainX
Fluorite | Level 6

Dear All,

 

I am new to SAS Studio on Demand (and SAS in general), thus I apologise in advance for my silly question.

 

I run a logistic regression with 100 obs, and 2 independent variables, one categorical ("Card") and one continuous ("Spending"). See the screenshots in the attached PDF.

 

In Excel/Minitab, I obtain the following coefficients: b0=-2.146, b2=1.099, b3=0.342

In SAS Studio, I obtain the following coefficients: b0=-1.0476, b2=-1.0987, b3=0.3416

 

May you clarify for me what happens with b0 and b1??? I am really going crazy. My questions:

 

a) Why the estimates for b0 are different, between Excel/Minitab and SAS?

b) Is it just luck that b0+b1 for SAS is equal to b0 for Excel/Minitab?

b) Why there are opposite signs for b2 (between Excel/Minitab and SAS)?

 

Once again I deeply apologise for this silly question.

 

Best, 

 

Alain

 

Minitab.pngSAS Studio.png

1 ACCEPTED SOLUTION

Accepted Solutions
SAS_Rob
SAS Employee

It looks like the Excel/Minitab is using a different reference level for Card.  SAS is setting the reference level to '1' while it appears the other package sets it to '0'.  

Regardless of the values however, the interpretation would be the same.

 

You can control the reference level on the CLASS statement.

class card(ref='0')/param=glm;

 

View solution in original post

2 REPLIES 2
SAS_Rob
SAS Employee

It looks like the Excel/Minitab is using a different reference level for Card.  SAS is setting the reference level to '1' while it appears the other package sets it to '0'.  

Regardless of the values however, the interpretation would be the same.

 

You can control the reference level on the CLASS statement.

class card(ref='0')/param=glm;

 

AlainX
Fluorite | Level 6
Millions, millions, millions of thanks.. I am so obliged. Now I realise the power of SAS communities, and the underlying learning curve is totally worths the efforts. Huge thanks.

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!

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.

Discussion stats
  • 2 replies
  • 734 views
  • 3 likes
  • 2 in conversation