Have you tried the SAS "data set option" RENAME= used with FROM (PROC SQL) or the SET statement (DATA step)? It's best to share code and related SAS log (pasted in your post or post-reply) for what you have tried in order to allow subscribers to provide useful feedback/comment on your situation. Also, having the SAS log information (at least some relevant code leading up to the problem/error), let's subscribers know what's going on. Lastly, SAS version, OS platform, and whether you are local/remote server connected helps too.
Scott Barry
SBBWorks, Inc.