Thank Mr. KurtBremser, If I would like to utilise the code below: %let report_date=%sysfunc(today(),ddmmyyn8.); to turn "report_date" is: + 1 previous working day (WHITHOUT holiday and weekend between) + 1 previous working day (WITH holiday and weekend between) Could you please instruct me the code for the 2 situations above!? I have tried below code: %let rprt_today = %SYSFUNC(TODAY(),yymmddn8.);
%let rprt_yesterday = put(intnx('DAY',today(),-1),yymmddn8.);
data temp;
today = &rprt_today;
yesterday = &rprt_yesterday;
run;
PROC IMPORT OUT= LOAN_OVERDUE_YESTERDAY
DATAFILE="&RPRT_DIR_LOAN.OVD-LN-&rprt_yesterday. - COPY.XLS"
DBMS=XLS REPLACE;
SHEET="SHEET";
RUN; but I got the notification: "ERROR: Physical file does not exist, z:\reports\loan collections\daily loan overdue report\OVD-LN-put(intnx('DAY',today(),-1),yymmddn8.) - COPY.XLS." From my observation, it might be because "rprt_today" turned out numeric value whilst "rprt_yesterday" turned out character value. Is it true?
... View more