Desktop productivity for business analysts and programmers

Year format:

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 104
Accepted Solution

Year format:

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?


Accepted Solutions
Solution
‎02-20-2015 04:58 PM
Community Manager
Posts: 2,691

Re: Year format:

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

View solution in original post


All Replies
Solution
‎02-20-2015 04:58 PM
Community Manager
Posts: 2,691

Re: Year format:

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

Frequent Contributor
Posts: 104

Re: Year format:

Thank you! It worked.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 288 views
  • 0 likes
  • 2 in conversation