Rename not working
Rename not working
(OP)
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?
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?
RE: Rename not working
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;