There's no need for a macro. Look at SAS BY group processing.
Quick example:
Proc sort data=SASHELP.class out=class; by sex;run;
proc means data=class;
By sex;
run;
This looks like homework so I suggest you at least try it rather than ask for someone to do it for you.
See support.sas.com/training/tutorial for YouTube tutorials. And you didn't attach any files.
... View more