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

Hello!

 

I need to use one model used in previous papers but, of course, do not know the code for that,

It is the regression of credit ratings on some indicator variables(like loss or income) and others(like sales).

As there are more than 20 different credit rating scores and I need to use some indicator variables, I am lost how to make the code.

 

I find many about using categorical predictors but unsure about categorial regressees. Maybe using Logit/Probit thing...

 

e.g. : Credit Rating = b0+b1Sales+b2Loss indicator+b3dividend indicator...

 

If you already have worked on credit rating regression like this, please share your wisdome!

 

Thank you!!!

 

Jerry

1 ACCEPTED SOLUTION

Accepted Solutions
PaigeMiller
Diamond | Level 26

I would use Partial Least Squares regression instead of ordinary least squares regression, and your indicator variables go into the CLASS statement, all variables go into the MODEL statement.

 

Documentation with examples:

https://documentation.sas.com/?docsetId=statug&docsetTarget=statug_pls_examples01.htm&docsetVersion=...

 

Logit and probit are only used when the Y-variable is categorical; it is not used when an X-variable is categorical and the Y-variable is continuous.

--
Paige Miller

View solution in original post

7 REPLIES 7
PaigeMiller
Diamond | Level 26

I would use Partial Least Squares regression instead of ordinary least squares regression, and your indicator variables go into the CLASS statement, all variables go into the MODEL statement.

 

Documentation with examples:

https://documentation.sas.com/?docsetId=statug&docsetTarget=statug_pls_examples01.htm&docsetVersion=...

 

Logit and probit are only used when the Y-variable is categorical; it is not used when an X-variable is categorical and the Y-variable is continuous.

--
Paige Miller
JKCho
Pyrite | Level 9
Thank you PaigeMiller!
I used the PROC PFS and notice that it does not work with the fixed variable code like absorb identifier;

Because my model has some control variables too I want to put them in the model. Do you happen to know how to use control variables within PLS?
PaigeMiller
Diamond | Level 26

Control variables ought to be included in the model the same as any other variables.

--
Paige Miller
JKCho
Pyrite | Level 9
Last question!
how canan I also put fixed effect code such as absorb ; with PROC PLS? I have known that the ABSORB statement does not work with PROC PANEL and PROC PLS. may need sth else?
PaigeMiller
Diamond | Level 26

There is no ABSORB statement in PROC PLS.

 

If you really have a class variable that needs an ABSORB statement in PROC GLM, you'd have to include it in the model as a class variable in PROC PLS.

--
Paige Miller
Ksharp
Super User

Buy Naeem Siddiqi 's book 

Intelligent Credit Scoring: Building and Implementing Credit Risk Scorecards, Second Edition

 

 

https://www.sas.com/store/books/categories/business-concepts-leadership/intelligent-credit-scoring-b...

JKCho
Pyrite | Level 9
Thank you for recommending the book!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 7 replies
  • 1492 views
  • 4 likes
  • 3 in conversation