topic Re: Macros -Loop for proc means in New SAS User

Macros -Loop for proc means

Maha_Kumaran — Fri, 08 Jul 2022 21:44:05 GMT

I am lookin for a macros code which can repeat the same step based on the variable and create separate output

my example data . I want to create aggregate (sum of population) at different levels of Age_1, Age_5 and Geo for each year. Orginally I am working with 30 Year data, would like to repeat proc means using macros

Year	Age_1	Age5	Geo	Population
2000	1	1 to 5	A	1.28
2000	3	1 to 5	A	2.35
2000	24	20-25	B	2.66
	…
2000	60		C	1.87
2019	1	1 to 5	A	2.35
2019	3	1 to 5	A	2.66
2019	24	20-25	B	2.66
2019	…			1.87
2019	60		C	1.87

PROC means DATA =test noprint sum;
class AGE_1 AGE_5 gender geo_levels;
var population;
output out=result sum=;
RUN;

Any help or pointers is really appreciated.

Thanks in advance

Re: Macros -Loop for proc means

PaigeMiller — Fri, 08 Jul 2022 21:49:52 GMT

Macros are probably not a good choice here. In your existing code, you have a data set named RESULTS which contains the sum for all values of Age_1, all values of Age_5 and all values of geo

If you need to split things up, don't use a macro and run PROC MEANS many times, just split RESULTS as needed. For example:

proc whatever data=results(where=(Age_1='1'));

data want;
    set results(where=(age_1='1'));
    ...
run;

Re: Macros -Loop for proc means

Reeza — Fri, 08 Jul 2022 22:08:17 GMT

Show two or three iterations of what proc means would look like if you were not using a macro. That helps to show how you the macro should be designed.

Re: Macros -Loop for proc means

Maha_Kumaran — Fri, 08 Jul 2022 22:33:14 GMT

Thank you.
I would like the proc means repeated for every fiscal year
Iteration 1:
PROC means DATA =test noprint sum;
class AGE_1 AGE_5 gender geo_levels;
var population;
Where year ="2000";
output out=result1 sum=;
RUN;

Iteration 2:
PROC means DATA =test noprint sum;
class AGE_1 AGE_5 gender geo_levels;
var population;
Where year ="2001";
output out=result2 sum=;
RUN;

I have 30Y data, I don't want to repeat proc means 30 times.
Hope this gives some clarity to my question.

Re: Macros -Loop for proc means

Maha_Kumaran — Fri, 08 Jul 2022 22:36:04 GMT

Thank you. But I am not looking to split by AGE_1. I want sum of populations at different levels of Age_1,AGE_5, Geo levels for each fiscal year

Re: Macros -Loop for proc means

PaigeMiller — Fri, 08 Jul 2022 22:41:53 GMT

@Maha_Kumaran wrote:
Thank you.
I would like the proc means repeated for every fiscal year
Iteration 1:
PROC means DATA =test noprint sum;
class AGE_1 AGE_5 gender geo_levels;
var population;
Where year ="2000";
output out=result1 sum=;
RUN;

Iteration 2:
PROC means DATA =test noprint sum;
class AGE_1 AGE_5 gender geo_levels;
var population;
Where year ="2001";
output out=result2 sum=;
RUN;

I have 30Y data, I don't want to repeat proc means 30 times.
Hope this gives some clarity to my question.

Add variable YEAR into your PROC MEANS in the CLASS statement.

PROC means DATA =test noprint sum;
    class year AGE_1 AGE_5 gender geo_levels;
    var population;
    output out=result2 sum=;
RUN;

No macro needed.

Re: Macros -Loop for proc means

Kurt_Bremser — Sat, 09 Jul 2022 06:22:02 GMT

That's very simply done with PROC MEANS. Sort your dataset by year, then combine BY and CLASS:

pric means data=test noprint sum;
by year;
class AGE_1 AGE_5 gender geo_levels;
var population;
output out=result1 sum=;
run;

Re: Macros -Loop for proc means

Maha_Kumaran — Fri, 15 Jul 2022 14:31:16 GMT

Thank you!