topic Re: date_manipulation in SAS Programming

date_manipulation

mauri0623 — Wed, 27 Mar 2024 17:52:55 GMT

I have a birthdate such as 01SEP60:00:00:00.

Length = 8

Format datetime16.

Informat anydtdtm40.

I want to get the year of this string. I tried birth_year = year(input(birthdate,anydtdte20.)); I did not get any erro but every birth_year came out as missing.

Thank you!

Re: date_manipulation

yabwon — Wed, 27 Mar 2024 18:37:43 GMT

b_y =  year(datepart(birthdate));

Bart

Re: date_manipulation

Tom — Wed, 27 Mar 2024 18:59:55 GMT

So you don't have a DATE (number of days). You have a DATETIME (number of seconds).

The YEAR() function needs a DATE value. You can convert a DATETIME value to a DATE value by using the DATEPART() function.