Coding various if statements in SAS

Sean_OConnor — Thu, 25 Feb 2021 14:00:00 GMT

Folks,

I have three numeric variables which range from 0 to n and I would like to compare if they match across records and if not which way to they disagree.

The name my variables are A , B and C. I've drawn the logic out in a 3 way Venn Diagram but I'm trying to write a if clause in SAS to extract out the information. I have 7 combinations in total.

A=B

A=C

B=C

A=B=C

I would like to have something written such as; if A=B=C then Cohort='ABC'

if A=B then Cohort='AB' and so on.

Any help on this would be great.

Re: Coding various if statements in SAS

Kurt_Bremser — Thu, 25 Feb 2021 14:14:30 GMT

In fact, you have only 5 "combinations":

no match
A=B
A=C
B=C
A=B=C

So my code would look like

data want;
set have;
if a = b and b = c then result = "all match";
else if a = b then result = "A=B";
else if a = c then result = "A=C";
else if b = c then result = "B=C";
else result = "no match";
run;

topic Re: Coding various if statements in SAS in SAS Enterprise Guide

Coding various if statements in SAS

Re: Coding various if statements in SAS