@Sas_rookie_sa wrote: I have a data set with dates from all year long. I'm trying to set up a macro to pass a sysparm to only evaluate data with a given year and a given quarter
Are you going to do this repeatedly, such that all year/quarter combinations in your data set are "evaluated" (whatever that means)?
No need for a macro in this case. This will get the job done (it is calculating means, but other statistics are available):
proc summary data=have nway;
class date;
var amount;
format date yyq6.;
output out=want mean=;
run;
In fact, this seems like a more efficient approach than repeatedly calling a macro, it should execute much faster, especially on large data sets. Please explain how you would use such a macro.
... View more