topic Skip missing values in a if statement in SAS Programming

Skip missing values in a if statement

hwangnyc — Mon, 14 Aug 2017 15:04:03 GMT

Hi everyone,

Here is some sample data:

I would like to create a simple variable "improvement" the code is

if X < Y then improve = 1; 
else improve = 0;

How can I get SAS to skip the rows where Y is missing? This is what I want:

Thanks in advance!

hwangnyc — Mon, 14 Aug 2017 15:08:55 GMT

Doh! I resolved my own post.

if missing(x) then improve =.;

tomrvincent — Mon, 14 Aug 2017 15:10:33 GMT

'skip' as in drop the records or 'skip' as in don't set a value for improve if y is missing? Or something else?

Reeza — Mon, 14 Aug 2017 15:14:51 GMT

if X < Y and not missing(Y) then improve = 1; 
else if not missing(Y) then improve = 0;

Another option for you: