Hello, I'm trying to utilize the macro below to prevent typing out this full sql query many times throughout the code. The into :&count is causing issues. Although it doesn't show an error, later when I call salescount, it's clear the macro was not assigned properly "Apparent symbolic reference salescount was not resolved." Is there a way to fix the macro or will I have to go back to writing each proc sql %macro counts (variable1, count, dataname);
proc sql;
select count(distinct &variable1) into :&count trimmed
from &dataname;
quit;
%mend counts;
%counts(userid, salescount, customers)
... View more