Converting character worddate. format into a date format?

Accepted Solution Solved
Reply
Contributor krm
Contributor
Posts: 26
Accepted Solution

Converting character worddate. format into a date format?

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! 

 

 

 

 


Accepted Solutions
Solution
‎05-03-2017 03:49 PM
Super User
Posts: 19,805

Re: Converting character worddate. format into a date format?

Try INPUT with ANYDTDTE informat.

 

 

View solution in original post


All Replies
Solution
‎05-03-2017 03:49 PM
Super User
Posts: 19,805

Re: Converting character worddate. format into a date format?

Try INPUT with ANYDTDTE informat.

 

 

Contributor krm
Contributor
Posts: 26

Re: Converting character worddate. format into a date format?

It worked! great information thanks a lot!

 

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

SAS Super FREQ
Posts: 8,866

Re: Converting character worddate. format into a date format?

Hi,

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

cynthia

read_char_date_val.png

Contributor krm
Contributor
Posts: 26

Re: Converting character worddate. format into a date format?

Posted in reply to Cynthia_sas

thank you @Cynthia_sas!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 108 views
  • 3 likes
  • 3 in conversation