Drop NA Values with SAS

Question

I have an xlsx file that I wish to delete the NA values in SAS. I'm new to SAS, how do I do this?

Answer 1

For numeric data(observations) in order to drop you can use missing and delete:

data olddata;
set cleandata;
if missing(coalesce(of _numeric_)) then delete;run;

Note: untested code