topic Re: Find first month in which flag occurs, across columns in SAS Programming

Find first month in which flag occurs, across columns

Anotherdream — Mon, 16 Jun 2014 03:29:11 GMT

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!

Re: Find first month in which flag occurs, across columns

Reeza — Mon, 16 Jun 2014 03:46:52 GMT

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.

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Re: Find first month in which flag occurs, across columns

Ksharp — Mon, 16 Jun 2014 03:46:54 GMT

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