BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Bellefeuille
Obsidian | Level 7

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!

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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.

View solution in original post

1 REPLY 1
ballardw
Super User

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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1012 views
  • 0 likes
  • 2 in conversation