如何利用SAS宏变量批量实现多变量PROC MEANS汇总？

You can create a reusable SAS macro that iterates over each variable in your &macroVar list, generating the PROC MEANS code dynamically. Here's how to do it:

Step-by-Step Solution #

First, define a macro that takes your variable list as input, then loops through each variable to generate the necessary PROC MEANS blocks:

%let macroVar = Var1 Var2;

Data new1;
Set old1 (keep= count &macroVar.);
Run;

/* Macro to generate PROC MEANS for each variable in the list */
%macro process_means(var_list);
    /* Localize macro variables to avoid global conflicts */
    %local num_vars i current_var;
    
    /* Calculate the number of variables in the input list */
    %let num_vars = %sysfunc(countw(&var_list.));
    
    /* Loop through each variable in the list */
    %do i = 1 %to &num_vars.;
        /* Extract the current variable from the list */
        %let current_var = %scan(&var_list., &i.);
        
        /* Generate PROC MEANS for the current variable */
        Proc means data = new1 nway missing noprint;
            Class &current_var.;
            Var count;
            /* Output dataset name matches original pattern (out_var1, out_var2) */
            Output out= out_%lowcase(&current_var.) sum=;
        Run;
    %end;
%mend process_means;

/* Execute the macro with your variable list */
%process_means(&macroVar.);

Key Details: #

• %local: Ensures the macro variables (num_vars, i, current_var) are only visible within the macro, preventing unintended side effects with global variables.
• %sysfunc(countw(...)): Counts the number of items in your variable list, so the loop knows how many times to run.
• %scan(...)): Pulls each individual variable from the &var_list parameter one at a time during each loop iteration.
• %lowcase(...)): Converts the variable name to lowercase to match your original output dataset names (out_var1, out_var2). If you prefer to keep the original case, you can remove this and use out_&current_var. instead.

This approach eliminates redundant code and makes it easy to add more variables to &macroVar later—just update the macro variable, and the macro will handle the rest automatically.

内容的提问来源于stack exchange，提问作者O.r.A.j.C