Year format:

[sdang]

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?

[ChrisHemedinger · Accepted solution]

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

[sdang]

Thank you! It worked.