How to get number of non-missing without running the entire frequency

[advoss]

Here's another solution.

proc sql noprint;

  create table nmiss_or_not as

    select sum(missing(j)) as NMISS,

           count(*) as TOTAL_ROWS

      from bigds;

  quit;