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:
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.