Delete rows with missing value with where statement

[afazfaz]

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 · Accepted solution]

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

[Ksharp]

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