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

试了很多次都不行