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
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sdang
Quartz | Level 8 sdang
Quartz | Level 8
Go to Solution

Year format:

Posted 02-20-2015 04:55 PM (1003 views)

I want this format "07Nov2010:00:00:000"  into just the year 2010 either with a new column or the existing column.  How do I go about to do that?

0 Likes
1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager ChrisHemedinger
Community Manager

Re: Year format:

Posted 02-20-2015 04:58 PM (1175 views)  |   In reply to sdang

Try one of the DT* formats, such as DTYEARw  You don't even need to create a new variable!.

More on this approach:

http://blogs.sas.com/content/sasdummy/2011/11/15/do-you-mind-if-we-dance-with-your-dates/

Chris

Check out SAS Innovate on-demand content! Watch the main stage sessions, keynotes, and over 20 technical breakout sessions!

View solution in original post

0 Likes
2 REPLIES 2
ChrisHemedinger
Community Manager ChrisHemedinger
Community Manager

Re: Year format:

Posted 02-20-2015 04:58 PM (1176 views)  |   In reply to sdang

Try one of the DT* formats, such as DTYEARw  You don't even need to create a new variable!.

More on this approach:

http://blogs.sas.com/content/sasdummy/2011/11/15/do-you-mind-if-we-dance-with-your-dates/

Chris

Check out SAS Innovate on-demand content! Watch the main stage sessions, keynotes, and over 20 technical breakout sessions!
0 Likes
sdang
Quartz | Level 8 sdang
Quartz | Level 8

Re: Year format:

Posted 02-20-2015 05:03 PM (915 views)  |   In reply to ChrisHemedinger

Thank you! It worked.

0 Likes

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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.

Watch SAS Enterprise Guide vs. SAS Studio on YouTube

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
  • 2 replies
  • ‎02-20-2015 04:55 PM
  • 1004 views
  • 0 likes
  • 2 in conversation