Date conversion error when I use proc import in SAS EG 5.1

[wtien196838]

When I import excel file into SAS dataset in EG 5.1, I got variables with date format error.

I use  : Proc Import datafile= <excel file.xls>

                            out=<sas dataset>

                            dbms=xls  replace;

                            getnames=yes;

All input fields are OK, only date fields have problems like that :

Excel format    SAS read in             SAS read in format

6/26/2014        41816                        06/27/2074

10/8/2013        41555                        10/09/2073

5/9/2011         40672                         05/10/2071

........................................

SAS read in date fields which are off 60 years and 1 day in each value.

The option yearcutoff = 1920 in default.

Would you mind giving me a direction to resolve this problem.

Thanks in advance.

----------------------------

WT1968

[Ksharp]

not sure if it could work. Did you try other engine ,like dbms=excel  dbms=xlsx .

options datestyle=mdy;

[art297 · Accepted solution]

It's a known problem. Take a look at: 41000 - Date values might be incorrect when you read Microsoft Excel files with the XLS engine

[wtien196838]

Thanks for all information. I appreciate your help to solve my problem quickly.