Hello everyone. I have a dataset that has thousands of loans (down the rows) by months (across columns). It is basically a giant matrix of yes /no values (1,0 in format).
Does anyone know a way to find the FIRST column (month) in which a yes flag occurs? Please see the following excel file example with the final column named "desired answer" for an example of the input and output that I am looking for.
If there is a way to do this without transposing the data it would be greatly appreciated, since the data is extremely large.
Please let me know if anyone has any questions on this request!
Your example has the first as 0/1/2 rather than 0/1, is that the actual case as your original question states 0/1?
If it's only 0/1 look at the whichn function across the months.
proc import datafile='c:\temp\monte carlo example.xls' out=have dbms=excel replace;run; data want(drop=i); set have; array x{*} month:; want=0; do i=1 to dim(x); if x{i} then do;want=i;leave;end; end; run;
Xia Keshan
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.
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.