topic Re: if-then statement not working in SAS Enterprise Guide

if-then statement not working

kfluegge — Thu, 13 Sep 2018 13:05:48 GMT

Hi. I have the if then statement below. "Disch" is a date variable (format YYYY-MM-DD). When running the code, the DEATH variable is blank even for records where the value of ddest = 20. I wish for the DEATH variable to be populated with the DISCH date when ddest = 20. This seems like it should be quite simple, but apparently I do not know how to do it.

if ddest = 20 then disch = DEATH;

Re: if-then statement not working

Astounding — Thu, 13 Sep 2018 13:14:55 GMT

It looks like you got it backwards:

if ddest = 20 then DEATH = disch;

It's a good idea to read the notes on the log. You should have seen something like this:

NOTE: The variable death is uninitialized.

That's SAS's way of saying that it doesn't exist so you can't copy from it.

Re: if-then statement not working

SuryaKiran — Thu, 13 Sep 2018 13:16:45 GMT

Does your source data have same datatypes for both of the variables disch & death. From what you explained it must be death=disch instead of the opposite way.

If they are of different datatypes then create a new variable or rename death from source dataset and create death in new dataset.

Re: if-then statement not working

ballardw — Thu, 13 Sep 2018 14:38:40 GMT

@Astounding wrote:

It looks like you got it backwards:

if ddest = 20 then DEATH = disch;

It's a good idea to read the notes on the log. You should have seen something like this:

NOTE: The variable death is uninitialized.

That's SAS's way of saying that it doesn't exist so you can't copy from it.

And you likely want to make sure that you have a date format of some type assigned to the DEATH variable if disch is a SAS date valued variable.