Here could give you a start.
%macro qa_counts(table_name = , month = , count_id = );
proc sql;
create table temp as
select "&table_name." as table_name length=40,
put(&month.,monname.) as month length=40,
count(distinct &count_id.) as count_id
from &table_name.
group by month ;
quit;
proc append base=want data=temp force;run;
%mend;
proc delete data=want;run;
%qa_counts(table_name = sashelp.stocks, month = date, count_id = stock)
proc print data=want noobs;run;
... View more