topic proc import date in SAS Procedures

proc import date

Steelers_In_DC — Fri, 12 Dec 2014 16:27:30 GMT

Proc import is bringing in a weird date, from 2014 to 2074. Is there anyway to correct it after it has been imported, or via proc import? I don't know that I can informat using proc import. I know I can datastep informat but if I can get around that (file changes monthly) I would much prefer too.

Thanks in advance.

Re: proc import date

Steelers_In_DC — Fri, 12 Dec 2014 18:25:31 GMT

date is formatted yyyy/mm/dd in excel,

Re: proc import date

Reeza — Fri, 12 Dec 2014 19:08:10 GMT

Is your variable name consistent between files?

Can you post sample excel file and import code that generates the issue?

Re: proc import date

Steelers_In_DC — Fri, 12 Dec 2014 19:42:34 GMT

the name is consistant:

Excel:

Process_date

2014/07/28

sas:

Process_date
2014/07/28

1

Re: proc import date

Steelers_In_DC — Fri, 12 Dec 2014 19:43:08 GMT

oops

sas:

1	07/29/2074

Re: proc import date

Steelers_In_DC — Fri, 12 Dec 2014 19:47:46 GMT

for the current month I used intck to come up with good_date = process_date - 21916; but that isn't anything that I would hand over to the business owner as a 'solution'.

Re: proc import date

Reeza — Fri, 12 Dec 2014 19:51:35 GMT

Your proc import code? Did you use scandate option?

Re: proc import date

Steelers_In_DC — Fri, 12 Dec 2014 19:58:34 GMT

PROC IMPORT FILE="C:\Users\pp78499\Desktop\SOP_IMPAIRED_TREND.xls"

OUT=Quarterly_Trend_Report

DBMS=xls

REPLACE;

SHEET="Change >5%"; scandate=no; scantime=no;

namerow=6;

startrow=7;

GETNAMES=YES;

RUN;

Re: proc import date

Reeza — Fri, 12 Dec 2014 20:17:53 GMT

And with scandate=yes what do you get?