The pure SQL way is to use dictionary.tables: proc sql noprint; /* noprint because we do not want to see the SELECT INTO results as a table */
select catx(' ','sum(',name,') as', name) into :sums separated by ','
from dictionary columns
where libname='WORK'
and memname='HAVE'
and upcase(name) like 'R%'
;
create table want as select
metric,
prod,
&sums
from have
group by metric,prod
;
quit;
... View more
