topic Re: Error while calculation of age in SAS Programming

Error while calculation of age

Tejaswini3 — Sat, 05 Mar 2022 09:53:01 GMT

Kindly check below code

data PKMERGE;
set PKDAR;
/*Derivation of age*/
age=intck('year',VSN1D, DOB1D, 'Continuous'); /*Check the age*/
run;

After running the above code, following log is appearing

NOTE: Character values have been converted to numeric
      values at the places given by: (Line):(Column).
      732:18   732:25
NOTE: Invalid numeric data, VSN1D='18APR2006' , at line 732
      column 18.
NOTE: Invalid numeric data, DOB1D='08JUL1955' , at line 732
      column 25.

Kindly assist in solving the problem

Re: Error while calculation of age

ChrisNZ — Sun, 06 Mar 2022 21:31:43 GMT

The message is quite clear.

Function INTK take numerical arguments (SAS dates) and you provide character arguments.

How was table PDKAR created?

Maybe you wrote

VSN1D='18APR2006';

instead of

VSN1D='18APR2006'd;

Re: Error while calculation of age

ChrisNZ — Sun, 06 Mar 2022 21:37:27 GMT

Note that to calculate age, this is arguable a better method:

AGE = floor(yrdif(DOB, today(), 'age'));