Asked • 04/24/19

Treat missing values as zero in SAS where clause?

Is there an equivalent of the Oracle NVL function in SAS? For example, if I have a where clause in SAS that says: where myVar > -2; it is not going to include any rows that have myVar = . If I want to treat missing values as zero, i have to say: where myVar > -2 or missing( myVar ) I'd like to be able to do something like: where NVL( myVar, 0 ) > -2 // or some SAS equivalent Is there something like this in SAS?

1 Expert Answer


Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.


Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.