I want to calculate the age of a customer but sas is giving me errors. Anyone know how to fix this? My Code: %let todaysDate = %sysfunc(today()) format date09.; PROC SQL; CREATE TABLE WORK.QUERY_FOR_TABLE AS SELECT t1.SubscriberKey, Datepart(t1.CustDOB) format date09. AS DOB, &todaysDate AS TodaysDate, intck('year', DOB, TodaysDate) as Age FROM CASE.CUSTOMERS t1 ; QUIT; RUN; Error Log: ERROR: Function INTCK requires a numeric expression as argument 2. ERROR: Function INTCK requires a numeric expression as argument 3. ERROR: The following columns were not found in the contributing tables: DOB, TodaysDate.
... View more