rename not working

[sap1958]

proc sql;
create table table1 as
select CustomerID,First,Last,
Web,Salary,Bonus,Birthdate,
Age, TotalSalary, Status
from
TestDb.tblCustomer1;
run;

data table2;
set table1;
rename Web=Email;
run;

My rename will not work. I am attempting to change Web to Email

 

[jj72uk]

What error are you getting as you are using the correct syntax?