如何在SAS重复PROC过程中动态生成指定标题（禁止硬编码）

Got it, let's solve this dynamic title problem for your repeated PROC calls! The key here is to pull the values of var1 and var2 directly from your dataset and inject them into the title without hardcoding. Here are two straightforward, scalable approaches:

1. Use Macro Variables (Single Dataset Case) #

First, we'll extract the unique values of var1 and var2 from your dataset into macro variables, then reference those variables in the title. This works perfectly if you're running the PROC once, or can refresh the macro variables each time before rerunning.

/* Step 1: Extract values from test1 into macro variables */
proc sql noprint;
    /* Trim removes extra whitespace from the values */
    select distinct var1 into :var1_val trimmed from test1;
    select distinct var2 into :var2_val trimmed from test1;
quit;

/* Step 2: Use macro variables in the title */
proc sgplot data=test1;
    series x=x y=y;
    title "var1=&var1_val and var2=&var2_val";
run;

Why this works: #

• proc sql noprint runs quietly without printing results to the log.
• The trimmed option ensures there are no extra spaces in your macro variables, so the title looks clean.
• When SAS resolves &var1_val and &var2_val, it replaces them with the actual values from your dataset (in this case, e and b).

2. Wrap in a Macro (Repeated PROC Calls) #

If you need to run this PROC multiple times with different datasets, wrapping everything in a macro makes it reusable and fully dynamic. Just pass the dataset name as a parameter, and the macro handles the rest.

/* Define a reusable macro for plotting */
%macro plot_with_dynamic_title(ds=);
    /* Extract values from the input dataset */
    proc sql noprint;
        select distinct var1 into :var1_val trimmed from &ds;
        select distinct var2 into :var2_val trimmed from &ds;
    quit;

    /* Generate the plot with dynamic title */
    proc sgplot data=&ds;
        series x=x y=y;
        title "var1=&var1_val and var2=&var2_val";
    run;
%mend;

/* Call the macro with your test dataset */
%plot_with_dynamic_title(ds=test1);

/* Call it again with another dataset (e.g., test2) later */
/* %plot_with_dynamic_title(ds=test2); */

Bonus: Handling Multiple Values #

If your dataset ever has multiple values for var1 or var2, you can adjust the PROC SQL step to concatenate them (e.g., using catx(', ', var1) instead of var1) to include all values in the title.

内容的提问来源于stack exchange，提问作者user1481397