topic Counting the number of rows that contain one or missing values in SAS Programming

Counting the number of rows that contain one or missing values

BenBrady — Fri, 04 Aug 2017 01:28:44 GMT

I have a large data set and want to count the number of rows that contain one or more missing values. Was just wandering how to go about doing this.

Cheers

novinosrin — Fri, 04 Aug 2017 01:39:53 GMT

Something like this pehaps:

data want;
set have end=last;
if cmiss(of _char_) or nmiss(of _numeric_)>=1 then count+1;

if last;
keep count;
run;