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
... View more