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!
'skip' as in drop the records or 'skip' as in don't set a value for improve if y is missing? Or something else?
if X < Y and not missing(Y) then improve = 1;
else if not missing(Y) then improve = 0;
Another option for you:
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.