DDMMMMYYYY

Bellefeuille — Fri, 17 Nov 2017 19:46:17 GMT

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!

Re: DDMMMMYYYY

ballardw — Fri, 17 Nov 2017 19:57:08 GMT

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.

topic DDMMMMYYYY in SAS Programming

DDMMMMYYYY

Re: DDMMMMYYYY