data have;
set sashelp.class;
if ranuni(-1) lt 0.5 then call missing(name);
if ranuni(-1) lt 0.5 then call missing(age);
run;
proc sql;
select cats('nmiss(',name,') as nmiss_',name) into : list separated by ','
from dictionary.columns
where libname='WORK' and memname='HAVE';
create table want as
select &list from have;
quit;
Ksharp
... View more