topic How to choose the latest date on a file where there is a Macro that sets the date for current in New SAS User

How to choose the latest date on a file where there is a Macro that sets the date for current

Hiandbye — Wed, 29 Sep 2021 13:59:00 GMT

Hello,

So I have a code that contains a macro for a date to always choose the current month. However the code uses a file that gets updated quarterly so that means unless I change the date manually it wont find the latest date file. I think a do loop macro can help? Any ideas?

Thank you!

%macro wrapper;
%if &pdefadjrun=1 %then %do;
%if %sysfunc(exist( file_name_&ReportDateYMD. ))^=1
%then %do;
%put NOTE: file_name_&ReportDateYMD. dataset does not exist;
%end;
%else %if %sysfunc(exist(file_name_&ReportDateYMD. ))=1
%then %do;

Re: How to choose the latest date on a file where there is a Macro that sets the date for current

PaigeMiller — Wed, 29 Sep 2021 14:12:57 GMT

I have to say that I am not sure I understand what you are asking.

Please describe the problem from scratch. Don't discuss code or macros, just describe what you are trying to do in words.

Re: How to choose the latest date on a file where there is a Macro that sets the date for current

Hiandbye — Wed, 29 Sep 2021 14:14:18 GMT

Thanks! I may have not explained this well. The macro in the code sets the current date but the above code uses a file that updates every quarter. So for example if I want to run this for today I will have to change the &ReportDateYMD to the latest available date file. Is there a way where SAS can find and use the latest available file no matter the current date macro?

Thanks!

Re: How to choose the latest date on a file where there is a Macro that sets the date for current

PaigeMiller — Wed, 29 Sep 2021 14:27:21 GMT

@Hiandbye wrote:
Thanks! I may have not explained this well. The macro in the code sets the current date but the above code uses a file that updates every quarter. So for example if I want to run this for today I will have to change the &ReportDateYMD to the latest available date file. Is there a way where SAS can find and use the latest available file no matter the current date macro?

Thanks!

Steps:

Read in all file names in the folder into a SAS data set. (There are plenty of posts here in the SAS Communities which give the code to do this)
Parse the file names to extract the name of the file with the most recent date.

All of this can be done in SAS data steps. No macros needed.