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

So many options, hard to decide what to do.  Any bottom-line suggestions?

 

Tentatively the following looks promising:

 

/selection=lasso stop=none choose=cvex cvmethod=random (10) modelaverage refit showpvals;

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

Can you use the at most succinct code to test your data at first place ?

something like

 

proc glmselect data = sas_3.combined_sorted;
class i_Day;
model i_50503 = i_Open--i_23604 / selection=stepwise ;

run;

 

 

After that ,add some more option you need ,and see which one generate the ERROR information.

View solution in original post

6 REPLIES 6
PaigeMiller
Diamond | Level 26

Use PROC PLS if you have lots of correlated X variables. PLS handles the correlation better than any method using OLS or variable selection methods.

 

But in response to your exact question, the options in GLMSELECT (and every other procedure) are all to be used in specific situations and not in other sitautions, and you've given us no information about your situation.

--
Paige Miller
Ksharp
Super User

Agree with Paige.

After running PROC PLS, you could get a table of variable importance ,pick up variables which  VIP>0.8 

NKormanik
Barite | Level 11
Suggestions please....

Before I head over to Proc PLS, I'd like to at least come up with some
results using GLMSELECT. Tried the following and received error:

ERROR: No sample yielded a valid model.

This was the code I used:

proc glmselect data = sas_3.combined_sorted
plot=all;
class i_Day
/ split
;
model i_50503 = i_Open--i_23604
/ selection=stepwise
select=cv
cvmethod=split(10)
cvdetails=all
choose=validate
stop=press
drop=competitive
hierarchy=none
showpvalues
stb
stats=(adjrsq aic aicc ase bic cp fvalue press rsquare sbc sl)
details=all
;
modelaverage
sampling=srs
tables=all
refit;
run;
PaigeMiller
Diamond | Level 26

ERROR: No sample yielded a valid model.

 

How can we possibly help? You haven't explained what you are trying to do, and we don't have your data. Even worse, I have very little experience with GLMSELECT and lots of experience with PLS.

--
Paige Miller
Ksharp
Super User

Can you use the at most succinct code to test your data at first place ?

something like

 

proc glmselect data = sas_3.combined_sorted;
class i_Day;
model i_50503 = i_Open--i_23604 / selection=stepwise ;

run;

 

 

After that ,add some more option you need ,and see which one generate the ERROR information.

NKormanik
Barite | Level 11

Thanks Ksharp, and all others here.  You folks are wonderful.

 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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
  • 6 replies
  • 1573 views
  • 3 likes
  • 3 in conversation