While loop, right?

[zimcom]

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

[PaigeMiller]

No loop needed. Use the WHICHC function.

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=lefunctionsref&docsetTarget=p...

Example at that link.

[zimcom]

@PaigeMiller @novinosrin 

All roads lead to Rome!

Power of SAS, thank you both!

[novinosrin · Accepted solution]

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

[zimcom]

@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

[novinosrin]

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;

[zimcom]

@novinosrin it just worked pergect!

Thank you SO VERY MUCH!