Hello Everyone,   I have a file which is already in sas7bdat form, and there is a variable with observation written in a usual way, for example I have "Derry Medical Center" instead of "Derry_Medical_Center". I need to do analysis for each of distinct observations so I use proc sql to save those distinct values as macro-variables "loc1", "loc2", ..., "loc10".    After some data processing processes, those distinct values become the variable names for another dataset and it is automatically transferred to "Derry_Medical_Center" by SAS. Now I want to rename those variable names as "site1", "site2", ..., "site10". So I used the code: rename=("&loc1"n=site1 "&loc2"n=site2)   The code works in SAS but is not working in my SAS Studio (University Edition). '&macro'n does not replace the blank with an underscore. Can someone please explain to me why and how to solve this issue?   ... View more