topic Counting the Length of Spells across month variables in SAS Procedures

Counting the Length of Spells across month variables

brettmullga — Fri, 08 Aug 2014 19:08:22 GMT

Data:

id	month2	month3	month4	month5
01	1	0	1	1
02	0	0	1	1
03	1	1	0	1
04	0	1	1	1
05	1	1	1	1
06	1	1	1	1

Output:

# of spells: 8

Avg. Length: 2.375

Median: 2

Max: 4

Min: 1

Frequency Table

The idea is that I want to treat this as survival data but I don't have a count of time. Thank you all in advance!

Reeza — Fri, 08 Aug 2014 19:26:43 GMT

Change your data structure as a starting point:

data have;

input id $2 month1 month2 month3 month4 month5 month6;

cards;

01 0 1 0 1 1 0

02 0 0 0 1 1 0

03 0 1 1 0 1 0

04 0 0 1 1 1 0

05 0 1 1 1 1 0

06 0 1 1 1 1 0

;

run;

data spells;

set have;

array months (6) month1-month6;

spell=0; duration=0;

do i=1 to 6;

if months(i)=1 then duration+1;

else if months(i)=0 and duration>0 then do;

spell+1;

output;

duration=0;

end;

keep id spell duration;

run;

brettmullga — Fri, 08 Aug 2014 20:08:48 GMT

Thank you. I now better understand how to use arrays; they are a powerful tool!