BookmarkSubscribeRSS Feed
robertrao
Quartz | Level 8

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;

end;

do i=1 to 11;

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

vext=extubate(i);

output vent_array2;

end;

end;

run;

2 REPLIES 2
Reeza
Super User

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;

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;

end;

if flag1 or flag2 =0 then output;

run;

ballardw
Super User

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;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1114 views
  • 3 likes
  • 3 in conversation