topic Re: Array in SAS Procedures

Array

robertrao — Thu, 25 Apr 2013 19:37:24 GMT

Hi,

Is there any way I can check for both the conditions and then output in the same dataset?????

Below I am doing it into seperate datasets and trying to merge later!!!!

ASSUMING BOTH HAVE EQUAL NUMBER OF ELEMENTS!!

Thanks

data vent_array1(keep=visit_id mrn1 vint) vent_array2(keep=visit_id mrn1 vext);

format vint vext datetime.;

set sum_vent;

array intubate{12} itb1-itb12;

array extubate{11} ext1-ext11;

do i=1 to 12;

if admission_date <= intubate{i} AND intubate{i} <= discharged then do;

vint=intubate(i);

output vent_array1;

end;

do i=1 to 11;

if admission_date <= extubate{i} AND extubate{i} <= discharged then do;

vext=extubate(i);

output vent_array2;

end;

run;

Re: Array

Reeza — Thu, 25 Apr 2013 19:53:40 GMT

You can flag the observation and then output them instead:

Add in two flag variables as below.

data vent_array1(keep=visit_id mrn1 vint) vent_array2(keep=visit_id mrn1 vext);

format vint vext datetime.;

set sum_vent;

array intubate{12} itb1-itb12;

array extubate{11} ext1-ext11;

flag1=0; flag2=0;

do i=1 to 12 while (flag1 eq 0);

if admission_date <= intubate{i} AND intubate{i} <= discharged then do;

vint=intubate(i);

flag1=1

end;

do i=1 to 11 while (flag2 eq 0) ;

if admission_date <= extubate{i} AND extubate{i} <= discharged then do;

vext=extubate(i);

flag2=1

end;

if flag1 or flag2 =0 then output;

run;

Re: Array

ballardw — Thu, 25 Apr 2013 19:55:09 GMT

Not sure where you're going with this but if I wanted similar data in one data set I would be strongly tempted to make two additional arrays to hold your VINT and VEXT per intubate for each record instead of creating multiple records.

Something like

Array vint{12} vint1 - vint12;

do i=1 to 12;

if admission_date <= intubate{i} AND intubate{i} <= discharged then vint{i}=intubate{i};

end;