Date Problems in SAS 9.3

OS2Rules — Tue, 03 Apr 2012 17:12:10 GMT

Hi All:

We are testing our code in SAS 9.3 and I have run across something odd.

We read a date and time field from an external pipe-delimited file using ANYDTDTM and the behaviour has changed since version 9.1. with:

attrib OpenDT length=8. format=datetime18. informat=anydtdtm17.;

In 9.1 - using ANYDTDTM17. and reading "02/04/09 08:48:11" returns 04FEB09 08:48:11,

in 9.3 - you get 02APR09 08:48:11

so the 9.1 version reads the date part of the data as MM/DD/YY and the 9.3 version reads it as DD/MM/YY.

1) Is there an alternative date-time format that I can use to read my data (without significant program changes)?

2) Can I modify the behaviour of the ANYDTDTM in any wat to tell it how to read the data?

3) Am I just going to have to read the field in as TEST and parse it?

4) Should I just ignore it and hope it changes back in the next version?

Thanks in advance.

OS2Rules — Tue, 03 Apr 2012 17:29:56 GMT

Here I go answering my own question -

SAS (in their infinite wisdom) added an option to control the format of the date when used this way as of version 9.2

OPTION DATESTYLE=MDY;

topic Date Problems in SAS 9.3 in SAS Programming