Rename not working

[sap1958]

proc sql;
create table Proj2 as
select Project, ProjectCode, Category, ProjectAmount
from Testdb.Project2;
run;

data Proj3(rename = (Project = Proj1));
set Proj2;
run;

When I run the second data set to change the name from Project to Proj1, the field name will not change. The code appears to be correct. Any ideas?

 

[jj72uk]

Your above code is slightly wrong, you have a run statement at the end of a proc sql statement.

Having said that...

Why not do it all in one step???

proc sql;
create table Proj2 as
select Project as Proj1,
ProjectCode,
Category,
ProjectAmount

from Testdb.Project2;
quit;