Create datasets based on a condition for each column

[Ksharp]

OK. I forgot you have hundreds of columns. Try this:

data have;
   input col  coll  colll;
datalines;
1     3    5       
2     5    2     
10   3    1
8     0    -10
;
data _null_;
 set sashelp.vcolumn(where=(libname='WORK' and memname='HAVE')) end=last;
 if _n_=1 then call execute('proc sql;create table want as select ');
 call execute(cat('sum(',name,'>=5) as ',name));
  if last then call execute('from have;quit;');
   else call execute(',');
run;

[celine9602]

Thank you so much. It works.