topic Re: Date format in SAS Data Management

Date format

Kayomole — Wed, 03 Aug 2016 14:49:18 GMT

Hi all,

I want to change the date format of my data to YYMMDD8. . The data has two different date formats. They are:

1. DD/MM/YY (DDMMYYw.)

2. DD/MM/YYYY (DDMMYY10.)

Usually, I use the code below to change the date to the needed format.

Dateform = INPUT(PUT(date,8.),YYMMDD8.);
FORMAT Dateform YYMMDD8.;
RUN;

However, when I run the code now, it reads the 'day' as 'year' for both date formats. Please how can I solve this problem? Thank you .

Re: Date format

RW9 — Wed, 03 Aug 2016 15:09:12 GMT

Can you clarify, you have data which is in SAS numeric date format? If so then you just need to apply the format statement, you wouldn't input(put) it again.

Re: Date format

Tom — Wed, 03 Aug 2016 15:29:19 GMT

It is reading the DD as the YY because that is what you told it do by using the YYMMDD informat instead of the DDMMYY informat.

Is your data in a numeric variable? If so then why did you show the values as having slashes in them?

Is your data in a character variable? If so then just use the INPUT() function on it. You should use a width of 10 to handle both the records with and without the century part of the year.

Dateform = INPUT(date,DDMMYY10.);

Re: Date format

Kayomole — Thu, 04 Aug 2016 08:38:25 GMT

Thank you. Dateform=INPUT(date,MMDDYY10.); works.