Proc Export on Monday only

ertweety — Tue, 15 Nov 2016 18:07:16 GMT

I have some code that exports daily to an excel report. There is one piece of code that I want to only export on Mondays. Here's what I have so far.

Data _NULL_ ;
if weekday(today())=1 then
call execute ('PROC EXPORT DATA=inv3
               OUTFILE= "J:\Performance.xlsx"
               DBMS=excel REPLACE;
               sheet="Inventory";
               RUN;');
run;

Re: Proc Export on Monday only

Kurt_Bremser — Tue, 15 Nov 2016 19:20:45 GMT

Looks good at first glance. Does it work as intended?

topic Proc Export on Monday only in SAS Programming

Proc Export on Monday only

Re: Proc Export on Monday only