BookmarkSubscribeRSS Feed
amylanza
Calcite | Level 5

Hello, 

 

Somehow my dates were input into my dataset wrong and I need to change them.

 

I have the dates as a string right now and they are in yyq6. format but in characters. So the current dates show 2017Q1, 2017Q2, etc. but are char$6 as a string.

 

What I want is to see 01JAN2017 for the string 2017Q1, 01APR2017 for the string 2017Q2 and so on. But not just a string of that - it needs to be a proper date format.

 

I feel like I have tried everything and at best it will error out and at worst it will set all of values for that variable to missing.

 

How can I do this??

 

Thank you for your help!!

1 REPLY 1

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 540 views
  • 2 likes
  • 2 in conversation