topic Re: First period in failure in SAS Programming

First period in failure

Ronein — Mon, 18 Mar 2019 09:24:03 GMT

Hello

For each customer I have follow up of 5 periods.

I want to create a new column with information of number of periods it took to customer to arrive failure.

For example:

customer1: 3

customer2: 1
customer3: 2

customer4: 0

How can I calculate it please?

Data RawData;
input id Follow1  Follow2 Follow3 Follow4 Follow5;
cards;
1 0 0 1 1 1
2 1 1 1 0 0
3 0 1 0 1 1
4 0 0 0 0 0
;
run;

Re: First period in failure

Kurt_Bremser — Mon, 18 Mar 2019 09:49:35 GMT

Another nice case for transposing to long format:

Data RawData;
input id Follow1  Follow2 Follow3 Follow4 Follow5;
cards;
1 0 0 1 1 1
2 1 1 1 0 0
3 0 1 0 1 1
4 0 0 0 0 0
;
run;

proc transpose data=rawdata out=trans (where=(col1 ne 0));
by id;
var follow:;
run;

data want;
merge
  rawdata
  trans (in=b)
;
by id;
if first.id;
if b
then first_failure = input(substr(_name_,7,1),1.);
else first_failure = 0;
keep id follow: first_failure;
run;

proc print data=want noobs;
run;

Result:

                                                              first_
id    Follow1    Follow2    Follow3    Follow4    Follow5    failure

 1       0          0          1          1          1          3   
 2       1          1          1          0          0          1   
 3       0          1          0          1          1          2   
 4       0          0          0          0          0          0

Re: First period in failure

RW9 — Mon, 18 Mar 2019 09:51:45 GMT

Something easy like:

data rawdata;
  input id follow1 follow2 follow3 follow4 follow5;
cards;
1 0 0 1 1 1
2 1 1 1 0 0
3 0 1 0 1 1
4 0 0 0 0 0
;
run;

data want;
  set rawdata;
  want=whichn(1,of follow:);
run;