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 !
WHERE is not compatible with using variable lists such as _ALL_. Time to try something else.
WHERE is not compatible with using variable lists such as _ALL_. Time to try something else.
data class;
set sashelp.class;
if cmiss(of _all_) then delete;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.