1
$\begingroup$

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? enter image description here

$\endgroup$
1
  • $\begingroup$ By “Delete the NA values” you mean observations ? You can delete all the missing observations but not the values ... in your dataset if you drop all observations that has 1+ missing that you loose almost all the data ... better is to impute the missing. $\endgroup$
    – n1tk
    Jan 27 '19 at 20:36
1
$\begingroup$

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

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.