topic Re: Date conversion error when I use proc import in SAS EG 5.1 in SAS Programming

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

wtien196838 — Sat, 10 Jan 2015 11:57:57 GMT

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 — Sat, 10 Jan 2015 12:55:36 GMT

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

options datestyle=mdy;

art297 — Sat, 10 Jan 2015 14:41:07 GMT

wtien196838 — Sat, 10 Jan 2015 21:05:58 GMT

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