topic Re: Correct date with swapped year and day values in SAS Programming

Correct date with swapped year and day values

Tom — Wed, 02 Sep 2015 14:58:24 GMT

This question was recently posted on stackoverflow.

I am working with a dataset containing a date variable with the format MMDDYY10.. The problem is, that the day, month and the year have been swapped.

The data set as it looks now:

Obs Date
1   11/01/1931
2   11/06/1930
3   12/02/2003
4   12/07/2018

What I would like is a date variable with the format DDMMYY10., or a similar:

Obs Date
1   31/01/2011
2   30/06/2011
3   03/02/2012
4   18/07/2012

Observation 1 is hence written as the 1st of November 1931, but really it is the 31st of January 2011.

Does anyone know how I can change this?

Re: Correct date with swapped year and day values

Tom — Wed, 02 Sep 2015 15:02:01 GMT

data have ;
  input olddate mmddyy10.;
  newdate = input(put(olddate,mmddyy6.),yymmdd6.);
  format olddate newdate yymmdd10. ;
  put (olddate newdate) (=);
cards;
11/01/1931
11/06/1930
12/02/2003
12/07/2018
;;;;

Re: Correct date with swapped year and day values

Tom — Sat, 05 Sep 2015 16:11:28 GMT

I am typing this on cell phone. I noticed that the code formatting did display in chrome browser on my cell phone.

Re: Correct date with swapped year and day values

Tom — Sat, 05 Sep 2015 16:13:13 GMT

It does not seem possible to edit replies on a cell phone.