BookmarkSubscribeRSS Feed
ertweety
Obsidian | Level 7

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;

1 REPLY 1

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1280 views
  • 0 likes
  • 2 in conversation