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 (1061 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 (1233 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

SAS Hackathon registration is open! Build your skills. Make connections. Enjoy creative freedom. Maybe change the world.

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 (1234 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

SAS Hackathon registration is open! Build your skills. Make connections. Enjoy creative freedom. Maybe change the world.
0 Likes
sdang
Quartz | Level 8 sdang
Quartz | Level 8

Re: Year format:

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

Thank you! It worked.

0 Likes

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 1062 views
  • 0 likes
  • 2 in conversation