proc import date

[Steelers_In_DC]

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.

[Steelers_In_DC · Accepted solution]

date is formatted yyyy/mm/dd in excel,

[Reeza]

Is your variable name consistent between files?

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

[Steelers_In_DC]

the name is consistant:

Excel:

Process_date

2014/07/28

sas:

Process_date
2014/07/28

1

[Steelers_In_DC]

oops

sas:

1	07/29/2074

[Steelers_In_DC]

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'.

[Reeza]

Your proc import code? Did you use scandate option?

[Steelers_In_DC]

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;

[Reeza]

And with scandate=yes what do you get?