About PaigeMiller

PaigeMiller · ‎12-17-2024

More information is requested. Please explain how the numbers are calculated when combining rows. Loan count, Curr balance and Contrib IO balance are obvious, the remaining columns it is not clear how you are getting the result. Please provide data as working SAS data step code (instructions and examples). We do not like to work with Excel files or copy/paste from Excel or screen captures.

PaigeMiller · ‎12-17-2024

I don't see the log. You have to show us the full log for PROC PLS, from the top where PROC PLS appears in the log, down to the last NOTE after PROC PLS, every line in the log between PROC PLS and the last NOTE. Screen captures are not preferred; copy the log as text and paste it into the window that appears when you click on the </> icon.

PaigeMiller · ‎12-17-2024

@harmonic Show us the code! Show us the log!

PaigeMiller · ‎12-17-2024

The answer to your first question is here: https://communities.sas.com/t5/Statistical-Procedures/VIP-values-in-PLS/m-p/114388#M6021 Since you said you tried that command "but doesn't work", please provide more information about what you did (the full PROC PLS code), what happened and what you saw that indicated it didn't work. Please, in the future, do not ever say "but doesn't work" by itself without more explanation that I just asked for.. Regarding your second question, you have to output the regression coefficients to a SAS data set and plot from there. Please use the command ods output parameterestimates=parms;

PaigeMiller · ‎12-16-2024

%inm does exist (In-Macro) as a macro you can include in your code. %macro inm(slist,s); /* SAS Macro %inm to see if &s is contained in a string or list &slist */ /* Borrowed from https://groups.google.com/forum/#!topic/comp.soft-sys.sas/fWcSDgg11tE */ %if %sysfunc(indexw(&slist,&s)) gt 0 %then 1 ; %else 0; %mend; Example of use: %let list=1 2 3 5 7; %let target = 22; %let abc=%inm(&list,&target); %put &=abc; %let target = 5; %let abc=%inm(&list,&target); %put &=abc;

PaigeMiller · ‎12-16-2024

Sorry, this explanation is very scattered across different posts, and still seems to be confusing to me. Please put all of the explanation of the logic of this problem in one new post, that covers as clearly as you can the real situation that you are working on. I am asking for complete and clear writing, leaving nothing out; I am not asking you to write about SAS or code.

PaigeMiller · ‎12-16-2024

More explanation is needed. In the second row, total is missing, how do you determine to add 0.64 to that row? More explanation is needed for row 1 as well.

PaigeMiller · ‎12-16-2024

Good point, @Kurt_Bremser about not rounding up To round down, you would use the FLOOR function in SAS

PaigeMiller · ‎12-16-2024

Should it be rounded? Well, that's up to you, it depends on how you intend to use the result. How to round it? age_rounded = round(yrdif(date_of_birth,date_of_admission,'AGE'));

PaigeMiller · ‎12-15-2024

What is the problem here? You can search the log for "uninitialized", just like you can search the log for "ERROR".

PaigeMiller · ‎12-14-2024

My bad, left something out, it should be proc summary data=sashelp.baseball; var nhits; output out=stats p90=p90; run; data want; if _n_=1 then set stats; set sashelp.baseball; if nhits >= p90 then output; run;

PaigeMiller · ‎12-14-2024

proc summary data=have; var yourvariablename; output out=stats p90=p90; run; data want; set have; if yourvariablename >= p90 then output; run;

PaigeMiller · ‎12-14-2024

It's a lot easier if you use PROC LOGISTIC instead of PROC GENMOD. There doesn't seem to be a reason in your problem description that you would have to use GENMOD. proc logistic data=train ... ; model y = x1 x2 ... ; score data=train out=trainpreds; score data=test out=testpreds; score data=outoftime out=outoftimepreds; run;

PaigeMiller · ‎12-13-2024

Using PROC LOGISTIC, see the example named "ROC analysis using separate training and validation data sets" here https://support.sas.com/kb/39/724.html So LOGISTIC does exactly what you want. This method does not work in PROC GENMOD, and its not clear to me how to do this with PROC GENMOD alone. Probably you will need PROC GENMOD + PROC PLM

PaigeMiller · ‎12-13-2024

That's exactly what I said.

Online Status	Offline
Date Last Visited	yesterday

Re: SAS interruption and problems with reinstallation

Re: Calculate time by comparing conditions and dates vertically

Re: Unable to open xls file

Re: selecting marker types and colors in proc sgplot

Re: A SAS Macro to Use ODS to Direct Graphics Output to a Specified Fo...

Re: proc pls : saving the model

Re: Combine the variable values vertically

Re: Combine the variable values vertically

Re: A SAS Macro to Use ODS to Direct Graphics Output to a Specified Fo...

Re: proc pls : saving the model

Re: Difference between dates in SAS doesn't match results

Restore Interactive Perspective in SAS Studio

Re: LSD test in PROC GLIMMIX

SAS Studio, SAS Server search/navigation bar

Re: PROC REPORT: How to apply same color to group headers and column h...

Re: selecting marker types and colors in proc sgplot

Re: proc pls method pcr plots

Re: Create a new Calclation based on multiple conditions

Re: Why I Still Trust This Community More Than Any AI Assistant

SAS Viya/SAS Studio — how to convert code to lower case?

Re: Merge two rows into one if the count of one row is 1.

Re: Proc PLS Viya 4 output tables VIP and Predictors Coeff

Re: Proc PLS Viya 4 output tables VIP and Predictors Coeff

Re: Proc PLS Viya 4 output tables VIP and Predictors Coeff

Re: Execute part of macro based on whether macro value is in a list

Re: Fill variables to reach a total

Re: Fill variables to reach a total

Re: Round age

Re: Round age

Re: uninitialized

Re: Output all values greater than 90th percentile?

Re: Output all values greater than 90th percentile?

Re: Logistic regression-calculate pred on out of time data

Re: logististic regression- work on train data or all data??

Re: logististic regression- work on train data or all data??

SAS Quant Community

SAS Global Forum