Hello, I am merging two rather large datasets each of which contain 4,000 variables and they both have the same variable names. Given the large number of variables, I am wondering if there a SAS procedure that would allow me to rename all of the variables in a single dataset at once? Perhaps by adding a simple suffix or prefix? I Googled around and found some PROC SQL options however, I am simply not familiar with SQL so the code was not very clear. I am using SAS version 9. Any help or references would be appreciated. Thank you.
... View more