topic Re: Conditional Logic with Multiple Conditions in SAS Programming

Conditional Logic with Multiple Conditions

abrice520 — Mon, 03 Jan 2022 21:30:02 GMT

I want to use two variables in my data set (CauseofDeath and ContributingFactorsofDeath) to create a new variable: COVDeathsBiobank

I'm not sure I'm translating this correctly into code. Here is what I am trying to do in words:

If the CauseofDeath contains the string "COV" AND/OR if ContributingFactorsofDeath=U07.1,

then COVDeathsBiobank=1

If both of these statements are false I wanted COVDeathsBiobank=0

There are some observations with just the first condition true, some with just the second condition true, and some with both true. Here is what I have:

DATA Aim1;
	SET Variables;
IF prxmatch("/COV/",CauseofDeath)  THEN COVDeathsBiobank=1;
IF ContributingFactorsofDeath= "U07.1" THEN COVDeathsBiobank=1;
	ELSE     COVDeathsBiobank=0;
RUN;

I'm trying to make sure I don't accidentally exclude observations that for example meet the second criteria but are coded as 0 in COVDeathsBiobank because the first criteria is false. Thank you!

Re: Conditional Logic with Multiple Conditions

ballardw — Mon, 03 Jan 2022 21:53:21 GMT

Without actual data it is hard to confirm though I might suggest an additional else so if the value is set with the first comparison you do not reset it with the following comparisons.

DATA Aim1;
	SET Variables;
IF prxmatch("/COV/",CauseofDeath)  THEN COVDeathsBiobank=1;
ELSE IF ContributingFactorsofDeath= "U07.1" THEN COVDeathsBiobank=1;
	ELSE     COVDeathsBiobank=0;
RUN;

Re: Conditional Logic with Multiple Conditions

abrice520 — Mon, 03 Jan 2022 22:08:13 GMT

Thank you this was exactly what I needed!