topic Re: Does SAS have a similar function to relaimpo function in R in Statistical Procedures

Does SAS have a similar function to relaimpo function in R

TerryWhitlock — Mon, 20 Nov 2017 22:53:33 GMT

I am working on a regression model but I'd like to get the relative importance or contribution percentages from all possible orderings of the predictors. Similar to an example output below of predictor variables to a target variable.

I've seen the relaimpo package in R...does SAS have a similar code/function that can give the contribution percentage of predictors to a target variable?

Easy_Reservation	7.3%
Preferred_Seats	5.9%
Flight_Options	5.1%
Ticket_Prices	5.3%
Seat_Comfort	9.2%
Seat_Roominess	7.5%
Overhead_Storage	6.3%
Clean_Aircraft	8.4%
Courtesy	9.2%
Friendliness	11.6%
Helpfulness	12.1%
Service	12.1%

Re: Does SAS have a similar function to relaimpo function in R

Damo — Tue, 21 Nov 2017 10:20:46 GMT

Hi @TerryWhitlock

It's the first time I hear about relaimpo, just to give you an idea of my expertise on that field...

But from SAS, using the SAS/IML module you can execute R code as long as you have the RLANG option "on" (default value is norlang).

Then , with the PROC IML you can directly use your R code.

Further details (including comments from Chris Hemedinger and Rick_SAS) and a sample code are available from Run R code inside SAS easily.

Hope that helps.

Cheers,

Damo

Re: Does SAS have a similar function to relaimpo function in R

Ksharp — Tue, 21 Nov 2017 12:58:43 GMT

You could do Decision Tree Regression.

And the output contain what you want.

Check

PROC HPSPLIT

Re: Does SAS have a similar function to relaimpo function in R

ChrisHemedinger — Tue, 21 Nov 2017 13:34:51 GMT

Just to expand on the response from @Ksharp, here's a link to the HPSPLIT documentation. And example of the graphical output:

PROC HPSPLIT is part of SAS/STAT, but it's not included as part of SAS University Edition. Since it's in a category of "high performance" procedures, it's not part of that learners bundle.

You might also be interested in this free "Ask the Expert" webinar about variable selection in SAS Enterprise Guide and SAS Enterprise Miner.

Re: Does SAS have a similar function to relaimpo function in R

StatDave — Tue, 21 Nov 2017 16:24:52 GMT

Effect importance is typically assessed using partial correlation and partial R-square. If the target response is binary, see this note. If the target is continuous and you are fitting an ordinary regression model, see this note which shows how to get cumulative R-square. Partial R-square for generalized models can be computed as discussed in this note.

Re: Does SAS have a similar function to relaimpo function in R

TerryWhitlock — Tue, 21 Nov 2017 16:26:55 GMT

Chris/KSharp
Thank you for pointing me to HPSPLIT function!

Just to help me in usage of the outputs on HPSPLIT...if the image below is my output. Would it be a fair interpretation that Growth is 37% percent of total, Dopant is 26% percent of total, Anneal Temp is 23% percent of total, Rotation is 12% percent of total in importance to target variable?

Re: Does SAS have a similar function to relaimpo function in R

Ksharp — Wed, 22 Nov 2017 12:17:41 GMT

I think you can say so. But I am not 100% certain .

The following is I quote from your example.

"This table shows that the predictor gTemp has the largest value. This means that the growth temperature of
substrate is the most important consideration in determining the usability of the sample."