topic Re: Date (numeric) variable incorrectly interpreted - How can I change format in SAS Procedures

Date (numeric) variable incorrectly interpreted - How can I change format

deleted_user — Thu, 30 Apr 2009 14:09:15 GMT

Hi

Please can someone help me solve this riddle.

I have a (system generated) NUMERIC variable in SAS which looks like this: 04AUG2006:00:00:00
It has both 'format & Informant' of Datetime20. However I need to create a new variable based on the ddmmyy. I've tried everything from substr to input, but it seems to give me an error and recognises the year as 1963. Any tips will be deeply appreciated:-)

Cheers!

Re: Date (numeric) variable incorrectly interpreted - How can I change format

data_null__ — Thu, 30 Apr 2009 14:48:13 GMT

I think you could simply use datepart function

new = datepart(old);
format new date9.;

Re: Date (numeric) variable incorrectly interpreted - How can I change format

deleted_user — Thu, 30 Apr 2009 15:22:42 GMT

Thankyou so much - that has worked brilliant.
Cheers