Drop NA Values with SAS 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?
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