Skip missing values in a if statement

[hwangnyc]

Hi everyone,

Here is some sample data:

X	Y
14	.
2	.
2	.
2	1
0	1

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:

X	Y	Improve
14	.	0
2	.	0
2	.	0
2	1	1
0	1	0

Thanks in advance!

[hwangnyc · Accepted solution]

Doh! I resolved my own post.

if missing(x) then improve =.;

[tomrvincent]

'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]

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

 Another option for you: