topic Re: While loop, right? in SAS Programming

While loop, right?

zimcom — Fri, 15 Feb 2019 19:39:33 GMT

Hi Community,

I want to do a while loop to scan the variables 01 - 09 and if all of them is 'yes' then the last column will be populated as 'yes', otherwise if ther eis one 'no' then the last column will be populated as 'no'

usubjid	ieorres_incl01	ieorres_incl02	ieorres_incl03	ieorres_incl04	ieorres_incl05	ieorres_incl06	ieorres_incl07	ieorres_incl08	ieorres_incl09	Inclusion
1001	yes	yes	yes	yes	yes	yes	yes	yes	yes
1002	yes	yes	yes	yes	yes	yes	yes	yes	yes
1003	yes	yes	yes	yes	yes	yes	yes	yes	yes
1004	yes	yes	yes	yes	yes	yes	yes	yes	yes
1005	yes	yes	yes	yes	yes	yes	yes	yes	yes

Re: While loop, right?

PaigeMiller — Fri, 15 Feb 2019 19:46:19 GMT

No loop needed. Use the WHICHC function.

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=lefunctionsref&docsetTarget=p0jfvenvsqk24vn1q2ypospoq9ij.htm&locale=en

Example at that link.

Re: While loop, right?

novinosrin — Fri, 15 Feb 2019 19:49:08 GMT

data want;
set have;
array t(*) ieorres_incl01-ieorres_incl09;
length Inclusion $3;
if 'NO' in t then Inclusion='NO';
else Inclusion='YES';
run;

Re: While loop, right?

zimcom — Fri, 15 Feb 2019 19:56:35 GMT

@PaigeMiller @novinosrin

All roads lead to Rome!

Power of SAS, thank you both!

Re: While loop, right?

zimcom — Wed, 20 Feb 2019 20:25:27 GMT

@novinosrin

I have a new situation where I need to the same to populate "Yes"/"No" in the last column based on the Yes/No from the previous column as above, but the variable names are quite random and how can I define trhe array in this case

array t(*) ieorres_incl01-ieorres_incl09;

Thank you!

Subject ID	Consent Obtained	Inclusion Met	Exclusion Not Met	Dose Volume Compliance	Correct Vial Received	Dosing Window	Sample Obtained	Flagged
1001	Yes	Yes	Yes	Yes	Yes	Yes	Yes
1002	Yes	Yes	Yes	Yes	Yes	Yes	Yes

Re: While loop, right?

novinosrin — Wed, 20 Feb 2019 20:29:02 GMT

How about using double dash var list as long as they follow the order that your sample suggests from left to right

array t(*) ConsentObtained--sampleObtained;

Re: While loop, right?

zimcom — Wed, 20 Feb 2019 20:40:56 GMT

@novinosrin it just worked pergect!

Thank you SO VERY MUCH!