topic Proper syntax for multiple 'and' conditions in if-then statement in New SAS User

Proper syntax for multiple 'and' conditions in if-then statement

bretthouston — Tue, 16 Jul 2019 20:29:32 GMT

Hello,

I am trying to satisfy multiple (3) conditions in an if-then statement. I think I have the syntax wrong as I'm not getting the output I would expect.

In the sample dataset below:

ID Date1 Date2 Date3 Type Status

1 23Aug12 26Aug12 21Aug12 A 1

1 23Aug12 26Aug12 24Aug12 B 0

2 23Aug12 26Aug12 27Aug12 C 0

2 23Aug12 26Aug12 . . 0

3 23Aug12 26Aug12 . . 0

4 23Aug12 26Aug12 21Aug12 B 0

I've tried the following:

data want;

set have;

if Date3<Date1 and Type='A' and Type is not missing then status=1;

else status=0;

run;

Essentially I want to create a new variable (status) with the output as above. Status would be 1 if date3 occurs before date1, the type is B, and date3 is not missing. I think the 'is not missing' part (or the second 'and') is messing things up.

Thank-you kindly in advance!

Brett

Re: Proper syntax for multiple 'and' conditions in if-then statement

novinosrin — Tue, 16 Jul 2019 20:39:02 GMT

if Date3>. and Date3<Date1 and Type='A'  then status=1;else status=0;

Re: Proper syntax for multiple 'and' conditions in if-then statement

Reeza — Tue, 16 Jul 2019 20:49:43 GMT

if Date3<Date1 and not missing(Type) then status=1;

Though if TYPE=A it's not missing anyways so you don't need to check for it.

EDIT: I don;t think you intended to have TYPE='A' as well, but if you need to test for multiple values you can use IN

Re: Proper syntax for multiple 'and' conditions in if-then statement

tsap — Tue, 16 Jul 2019 20:49:22 GMT

So there seems to be some discrepancies between what you are showing in your 'status' column values vs. the coding logic you have vs. the statement you made at the end. In the last paragraph you state that you want observations where Type='B', however your code and table seem to show that you are calling out observations with Type='A'.

Additionally in the last paragraph you state that the third piece of criteria is that Date3 cannot be missing, but in your code you never reference this. You just say where 'Type' is not missing.

So if we are assuming that what you want is what you described in your final paragraph:

- Date3 < Date1

- Type='B'

- Date3 is not missing

The logic below should work for you.

DATA WORK.WANT;
	SET WORK.HAVE;
	IF (Date3 < Date1) AND Type='B'	AND Date3 NE .  THEN Status=1;
	ELSE Status=0;
RUN;

Re: Proper syntax for multiple 'and' conditions in if-then statement

tsap — Tue, 16 Jul 2019 20:51:29 GMT

I'm pretty sure the type not missing piece of the code is a mistake. The paragraph afterwards states that the third criteria is that Date3 is not missing, and not Type. I thought the same thing you did at first and saw the Type not missing logic as an unnecessary redundancy. Then I realized that wasn't the correct variable being referenced.