Hello everyone, I have an SQL procedure in which I want to aggregate data with a group by procedure. I use a macro variable list because the level of aggregation needed might change. However, there is always one variable that I want to exclude from that list at that step and I don't know how to proceed. What I have right now: %LET CATEG = %str(VAR1, VAR2, VAR3, EXCL);
%LET CATEG2 = %str(VAR1, VAR2, VAR3);
proc sql noprint;
create table WANT as
select &CATEG.,
sum(Nobs_last) as CAT_Nobs_last,
sum(Nobs) as CAT_Nobs
from HAVE
group by &CATEG2.
order by &CATEG.;
quit; What I would like to have: %LET CATEG = %str(VAR1, VAR2, VAR3, EXCL);
proc sql noprint;
create table WANT as
select &CATEG.,
sum(Nobs_last) as CAT_Nobs_last,
sum(Nobs) as CAT_Nobs
from HAVE
group by &CATEG. [with an function that let me exclude the var EXCL]
order by &CATEG.;
quit; Thank you very much for your time, Cheers!
... View more