topic Re: Converting character worddate. format into a date format? in SAS Programming

Converting character worddate. format into a date format?

krm — Wed, 03 May 2017 19:30:07 GMT

Hi,

The dataset that I have, has the date as a character format.

For example:

April 1, 2017

I used input function but it didn't work.

Is it possible to convert this to a date format?

Thank you for the help!

Reeza — Wed, 03 May 2017 19:45:31 GMT

Try INPUT with ANYDTDTE informat.

krm — Wed, 03 May 2017 19:49:44 GMT

It worked! great information thanks a lot!

input(date,ANYDTDTE32.) as new_date format date10.

Cynthia_sas — Wed, 03 May 2017 19:50:47 GMT

Hi,

The INFORMAT of ANYDTDTE. worked for me as shown below.

cynthia

krm — Wed, 03 May 2017 19:53:30 GMT