如何给新加入的column赋值

datapayroll;

inputname $6. dateofhire:date9.gender $ dateofbirth:date9. salary:dollar7.;

cards;

Robert23MAR2007 M 21FEB1979 $32,000

John   15Jan2012 M 15JUL1985 $35,000

Lynn   10MAY2015 F 10MAR1990 $25,000

;

run;

procsql;

createtable employee as

select* from work.payroll;

altertable employee

addage num

modifydateofhire date format=mmddyy10.;

quit;

我想加入一个new column叫age,然后给age赋值，请问如何做。可以用这个function吗 int((today()-dob)/365.25

试了很多次都不行

proc sql;
create table employee as
select*, ((today()-dateofbirth)/365.25) as age from work.payroll;
quit;

procsql;
Please try use this:
createtable employee as

select*,  ((today()-dob)/365.25 as AGE from work.payroll;

quit;

suzhzh 发表于 2016-7-8 09:29
procsql;
Please try use this:
createtable employee as

thanks for your answer.
but still doesn't work out.
:(

1. data payroll;
   
2.         input name $ dateofhire date9. gender $ dateofbirth date9. salary dollar8.;
   
3.         cards;
   
4.         Robert 23MAR2007 M 21FEB1979 $32,000
   
5.         John 15Jan2012 M 15JUL1985 $35,000
   
6.         Lynn 10MAY2015 F 10MAR1990 $25,000
   
7. ;
   
8. run;
   
9. 
   
10. proc sql;
    
11.         create table employee as
    
12.         select *, int((today()-dateofbirth)/365.25) as age from work.payroll;
    
13. quit;

复制代码

1. data payroll;
   
2.         input name $ dateofhire date9. gender $ dateofbirth date9. salary dollar8.;
   
3.         cards;
   
4.         Robert 23MAR2007 M 21FEB1979 $32,000
   
5.         John 15Jan2012 M 15JUL1985 $35,000
   
6.         Lynn 10MAY2015 F 10MAR1990 $25,000
   
7. ;
   
8. run;
   
9. 
   
10. proc sql;
    
11.         create table employee as
    
12.         select *, int((today()-dateofbirth)/365.25) as age from work.payroll;
    
13. quit;

复制代码