Hi, I am very new to programming in SAS. I have a relatively simple problem that I haven't been able to solve. I  want to log transform >1000 variables.  I'm trying to use a sas macros to a)  generate a list of all the variables that I want to transform b) calculate the transformed variable and call them prefix.oldvarname.   I used the following script to create a list of variable names (vlist) but apparently its just an array of text and not a list of variables.  Any suggestions?  Thanks. %macro getvars(dsn);     %global vlist;     proc sql;         select name into :vlist separated by ' '         from dictionary.columns         where memname = upcase("&dsn") and TYPE="num";     quit; %mend; ... View more