DATA Step, Macro, Functions and more

Proc Export on Monday only

Reply
Occasional Contributor
Posts: 15

Proc Export on Monday only

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;

Super User
Posts: 7,866

Re: Proc Export on Monday only

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 213 views
  • 0 likes
  • 2 in conversation