Hello, I think that yrdif statement could be helpful. For example : proc sql; select employee_id, employee_name, int(yrdif(emp_Hire_date,today(),"ACTUAL")) as tenure, Salary,int(yrdif(Birth_date,today(),'ACTUAL')) as Age from arturo.salesstaff order by tenure desc; SAS(R) 9.3 Functions and CALL Routines: Reference Best regards Damian Panek
... View more