DDMMMMYYYY

[Bellefeuille]

Good Afternoon

Im wondering if there is any way to convert a Text date that looks like 02JAN2017

Since im simply reading a dataset that has the date stored in this manor, im extracting it using a select statement, if at possible to convert or substring it from there and convert it, would be Best for me newbie self 🙂

any help is greatly appreciated

happy friday!

[ballardw · Accepted solution]

In a data step, since you have already read the data:

SASDate = input(yourdate, date9.);

format SASdate date9. ; /* or any of the other date formats humans like*/

in sql it would be

input(yourdate,date9.) as SASDate format=date9.

Best would be to read the data initially.