data a;
input a b c $;
datalines;
1 . a
. 5 .
; run;
options symbolgen mprint mlogic; %macro missing(lib=work ,dsn=a );
proc sql noprint;
select name into :col1 - :col9999
from dictionary.columns
where libname=upcase("&LIB")
and memname=upcase("&DSN");
quit;
data _null_;
if 0 then set a nobs=nobs;
call symput('nobs',put(nobs,12.-l));
stop;
run;
data b;
set &&LIB..&DSN;
%do i=1 %to &sqlobs;
if &&col&i=" " then &&col&i=0;