topic Delete rows with missing value with where statement in SAS Programming

Delete rows with missing value with where statement

afazfaz — Sun, 05 Nov 2017 13:58:05 GMT

Hello,

I'm a SAS newbie and I'd like to delete rows with at least one missing value with the WHERE statement.

data example2;
set example1;
where _ALL_ is not missing;
run;

I receive this error :

Variable _all_ is not on file work.example1.

I know there are different ways to achieve my goal but I'd like to try it with WHERE and _ALL_.

Thank you !

Astounding — Sun, 05 Nov 2017 17:56:45 GMT

WHERE is not compatible with using variable lists such as _ALL_. Time to try something else.

Ksharp — Mon, 06 Nov 2017 13:13:56 GMT

data class;
 set sashelp.class;
 if cmiss(of _all_) then delete;
run;