cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
Smitha9
Fluorite | Level 6 Smitha9
Fluorite | Level 6

date format with dashes

Posted 08-22-2023 03:13 PM (2210 views)

I have a dataset with

20170306

20180306

I want to change to 

2017-03-06

2018-03-06

with dashes.

 

 

0 Likes
Reply
2 REPLIES 2
Reeza
Super User Reeza
Super User

Re: date format with dashes

Posted 08-22-2023 03:19 PM (2202 views)  |   In reply to Smitha9
What is the variable type? If it's numeric with a date format, such as YYMMDDN8. you can switch it to YYMMDDD8. instead.

format variableName YYMMDDD8.;
0 Likes
Reply
Astounding
PROC Star Astounding
PROC Star

Re: date format with dashes

Posted 08-22-2023 03:30 PM (2196 views)  |   In reply to Reeza

Right idea, but switch instead to the YYMMDDD10. format to allow for a four-digit year.

Reply

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Watch Mastering the WHERE Clause in PROC SQL on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • ‎08-22-2023 03:13 PM
  • 2211 views
  • 4 likes
  • 3 in conversation