how to check blank value in a sas dataset?

shiyiming

hello everyone,
       my question likes this,
       i want to check if there is missing value in my dataset, always i will code below,
       data checktmp;
       set mydataset;
       if var_a='' or var_b=. or var_c=. then output;
       run;
       while if there are so many variables and i am so tired to type every columns there, so does there have any option will help me? thanks.

shiyiming

%macro outmissing(data = ,var= ,out = );
data &out;
    set &data.(keep=&var.);
            array arraynum{*} _numeric_;
    do i = 1 to dim(arraynum);
      if arraynum{i} = . then output;
    end;
    array arraychar{*} _character_;
    do i = 1 to dim(arraychar);
      if arraychar{i} = ' ' then output;
    end;
run;
proc print;
run;
%mend outmissing;
data a;
do i = 1 to 3;
  x = i**2;
  y = substr('abc', i, 1);
  if i = 1 then x = .;
  if i = 2 then y = ' ';
  output;
end;
run;
%outmissing(data = a, var=x, out = b);

shiyiming

data aa;
input f b c d e;
cards;
1 2 . . 3
. . . . .
2 3 4 5 6
;
run;

data bb;
set aa;
array missing  f b c d e;
do over missing;
   if missing=. then output bb ;
end;
run;

proc sql;
      create table cc as
      select distinct *
      from bb;
quit;

shiyiming

many thanks gzgoon and smand008 for so quick reply. and your code really help me.