12-12-2014 11:27 AM
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.
12-12-2014 02:47 PM
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'.
12-12-2014 02:58 PM
PROC IMPORT FILE="C:\Users\pp78499\Desktop\SOP_IMPAIRED_TREND.xls"
SHEET="Change >5%"; scandate=no; scantime=no;
Need further help from the community? Please ask a new question.