Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rename not working

Status
Not open for further replies.
sap1958

sap1958

Technical User
Joined
Oct 22, 2009
Messages
138
Location
US
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?
 
Sort by date Sort by votes
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;
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sap1958
  • Locked
  • Question Question
rename not working
Replies
1
Views
230
jj72uk
jj72uk
sap1958
  • Locked
  • Question Question
Birthdate calculation not working
Replies
6
Views
524
jj72uk
jj72uk
ks01
  • Locked
  • Question Question
Century Portion of Date Not Displaying Dates Correctly
Replies
4
Views
485
sasbuddy
sasbuddy
shelby55
  • Locked
  • Question Question
Array Not Working
Replies
1
Views
223
klaz2002
klaz2002
STRookie
  • Locked
  • Question Question
Identifying data where month is not equal to specified month
Replies
2
Views
338
kdt82
kdt82

Part and Inventory Search

Sponsor

Back
Top