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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.