data want; set have; by custid; if first.custid or balance>=0 then consec=0; if balance<0 then consec+1; run; Then use PROC SUMMARY to find the max of CONSEC by CUSTID. ... View more

You can drag the .sas file into the program editor or enhanced editor in the SAS 9.4 window.   But typically, I do not do this, I use the SAS 9.4 interface to open files. File->Open ... View more

Something like this:   if id=4 and rand('uniform')<0.3 then id=2; else if id=3 and rand('uniform')<0.1 then id=2; ... View more

Please provide example data as working SAS data step code (examples and instructions) and not as screen captures, not as Excel files, not as any other file attachment, not as copy/paste from Excel.     ... View more

The error you posted above looks like you are not trying to open the same data set. PROC PLS created OUTSIM.M08F_VS801A1_D01_PEST but your error message shows you are trying to open _TEMP16.M08F_VS801A1_D01_PEST.   We're trying to help you, but you have to help us as well. From now on, when we request the log, we want the log provided as we requested, which is not as a file attachment, but as stated above "copy the log as text and paste it into the window that appears when you click on the </> icon". We don't want hundreds of lines of the log before PROC PLS, we want the log between the line that says PROC PLS and the last line of the log for PROC PLS which is the NOTEs after the PROC PLS code. ... View more

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. ... View more

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. ... View more

@harmonic  Show us the code! Show us the log! ... View more

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;   ... View more

%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;     ... View more

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.     ... View more

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. ... View more

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