Hi, I've currently have a macro written for a single variable that looks like: %macro singlevar(var) ; Proc sql ; Create table temp as select &var, sum(Sales) as Sales From DataTable Group by &var Order by &var ; quit ; %mend ; I'm currently lost trying to write the macro to be dynamic with essentially an infinite number of variables to group by. %macro Multivar(var1, var2, var.etc.) ; Proc sql ; Create table temp as select &var, &var2, &var.etc, sum(Sales) as Sales From DataTable Group by &var, &var2, &var.etc Order by &var, &var2, &var.etc ; quit ; %mend ; Thank you in advance for the help!
... View more