SAS - convert macro variable space delimited list to comma delimited

SAS_macro_variable_space_comma.sas

*An example/demo of how to convert a macro variable list that is space delimited to comma delimited.

%Let weightvar = WEIGHT HEIGHT AGE;

*uses the translate function to replace spaces with commas. If VALIDVARNAME=ANY this may not work;
%macro addCommas(varList=);
     %sysfunc(translate(&varList, %str(, ), %str( )))
%mend addCommas;

*example recoding;
%let comma_delimited_list = %addCommas(varList = &weightvar);

%put &comma_delimited_list;

*example of in line usage within a procedure or data step;
data class;
set sashelp.class;
useless_variable = sum(%addCommas(varList = &weightVar.));
run;