Revision history [back]

You can generate a macro in SAS to create new variables by applying a logic to the selected variables by following these steps:

1. Define the macro with a name and any necessary parameters. For example:

%macro create_new_vars(vars=, prefix=, suffix=);

In this example, the parameters are "vars" to specify the selected variables, "prefix" to add a prefix to the new variable name, and "suffix" to add a suffix to the new variable name.

1. Use the %let statement to assign the variable names that you want to use for the new variables. For example:

%let new_var1 = &prefix..newvar1.&suffix;
%let new_var2 = &prefix..newvar2.&suffix;

1. Use the data step to create the new variables and apply the logic that you want. For example:

data new_data;
set old_data;
&new_var1 = sum(&vars);
&new_var2 = mean(&vars);
run;

In this example, "&vars" represents the list of variables that were selected, "&newvar1" is the name of the new variable that represents the sum of the selected variables, and "&newvar2" is the name of the new variable that represents the mean of the selected variables.

1. End the macro with the %mend statement. For example:

%mend create_new_vars;

1. When you want to use the macro, simply call it with the appropriate parameters. For example:

%create_new_vars(vars=var1-var5, prefix=new_, suffix=_calc);

In this example, the selected variables are var1, var2, var3, var4, and var5, and the new variables will have the prefix "new" and the suffix "calc".