Hi all! For most of my reports I am able to just use &eom. in my file extensions, but for a project I am working on, I need to be able to import a file based on its file extension of the previous Wednesdays date in DDMMYYN8. format. I have looked through the other questions and found the following, but when I use it, it exports with the SAS date format and not the format I want, and I cant seem to figure out how to format it. data _null_; today="&SYSDATE9"d; lastwk=intnx('week', today, -1); lastwed=intnx('week.4', lastwk , 1); run;
... View more