topic Re: Yrdif FUNCTION using Numeric BEST12 Format to Calculate Age in SAS Programming

Yrdif FUNCTION using Numeric BEST12 Format to Calculate Age

mglogan — Sun, 09 Dec 2018 04:53:18 GMT

Hello, I am trying to calculate an age variable.

The input format of brth_date (birth date) and scrn_date (screening date) is datetime 22.3.

the output format is numeric best12.

I am receiving the error: "Invalid character data" (Log below)

Any help would be appreciated.

Thank you!!

brth_date = datepart (brthdat);

if recorddate > . then scrn_date = datepart (recorddate);
else scrn_date = datepart (icdat);

age = floor(yrdif (brth_date, scrn_date,'age'));

Re: Yrdif FUNCTION using Numeric BEST12 Format to Calculate Age

Jagadishkatam — Sun, 09 Dec 2018 08:08:59 GMT

Could you please check if you have the age already derived in DM1 dataset.

Re: Yrdif FUNCTION using Numeric BEST12 Format to Calculate Age

mglogan — Sun, 09 Dec 2018 08:36:20 GMT

Wow, so when I initialized the variables in the dm1 data set, I accidentally set age = ' ' instead of age = .

Thank you!