How do I convert a 6 position date format to a 10 position date format?

Hi

Assuming the date is stored as text then:

DATA _NULL_;
  Old_date = '112310';
  SAS_Date = INPUT(Old_date, mmddyy.);
  New_date = PUT(SAS_Date, mmddyy10.);
  PUT _ALL_;
RUN;

Effectively, this ocde converts a text field to a SAS date, and then makes that SAS Date into a new text field in the format mm/dd/yyyy.

Hi theartfuldazzler,

Thanks for responding so quickly.

Is there a way to keep the 'Old_date" name?

Hi

DATA _NULL_;
  Old_date = '112310';
  SAS_Date = INPUT(Old_date, mmddyy.);
  Old_date = PUT(SAS_Date, mmddyy10.);
  PUT _ALL_;
DROP SAS_Date;
RUN;

Hi

You might have an issue with the length of the Old_Date.  If you place a format statement before the SET statement, it should work.


DATA _NULL_;
format Old_Date $10.;
  Old_date = '112310';
  SAS_Date = INPUT(Old_date, mmddyy.);
  New_date = PUT(SAS_Date, mmddyy10.);
  PUT _ALL_;
RUN;

Thanks,
Let me try it and be right back.

Hi,

I'm not getting it... Here is the section of the log with the error message.

2652  Date = input(stat_date,mmddyy.);
2653  Stat_date = put(date, mmddyy10.);
                            ---------
                            48
ERROR 48-59: The format $MMDDYY was not found or could not be loaded.

stat_date is in the mmddyy format, is text with length $6.

Okay Thanks,
I will be back in an hour...

Hi

Its 10pm on my side of the world, I will look again tomorrow first thing

I was able to make the conversion:

stat2_date = input(stat_date,mmddyy6.);
format stat2_date mmddyy10.;
stat_date = put(stat2_date,mmddyy10.);

Thanks,

Please cancel this request to close without assigning points

Hi

Just interested - but the answer I gave works - and is identical to your answer...  why no points?

Hi theartfuldazzler,

I put in a request for the cancel so I can give you the points.

Sorry about that.

As per comment ID: 34970400, the author agrees that comment ID: 34945923 is the correct solution, and should be granted the points.

Thanks again!