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:
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.