topic Re: Check fileexist then run a code or sent missing file email in SAS Programming

Check fileexist then run a code or sent missing file email

Gpp — Fri, 24 May 2019 13:25:06 GMT

Hi all,

I got a report that need input file from user, I wish to automate it so if user had put the file in the path then run the report_code.sas , else send out an email to remind them.

What I plan to do is ,build a new control code, by using Macro to check fileexist , if yes , then run %include “&path./report_code.sas” , if no then send a auto email.

I just notice that %include in a macro will caused an error. Even though the %include was successfully run. Any other method can recommend to me to avoid the error due to %include in a macro ?

Thanks in advance !

Re: Check fileexist then run a code or sent missing file email

VDD — Fri, 24 May 2019 13:36:46 GMT

I hope that when you get your logic to preform as expected that you don't spam the reports generator with the email, please send me the file """ every 5 minutes. People at work are trying to do the same thing not allowing enough sleep time.

Re: Check fileexist then run a code or sent missing file email

Patrick — Fri, 24 May 2019 14:07:49 GMT

@Gpp

"I just notice that %include in a macro will caused an error."

You can do what you want if your syntax is correct. We can't help much though if you don't share your not yet working code with us; plus the error in the log or a description of the undesired behavior and how it should behave.

Re: Check fileexist then run a code or sent missing file email

Gpp — Fri, 24 May 2019 15:00:02 GMT

hi Patrick, yes, I found my error and it' working ! thanks for the comment 😃

Re: Check fileexist then run a code or sent missing file email

Amir — Fri, 24 May 2019 15:18:26 GMT

It's good that you found your solution, it would be even better if you shared it with the community so that others may also benefit.

Amir.

Re: Check fileexist then run a code or sent missing file email

Gpp — Fri, 24 May 2019 15:49:20 GMT

Sure!

%macro findfile;
	%if %sysfunc(fileexist("&sharepath./INPUT/&filename..xlsx")) %then %do;
		%include "&path./CODE/LI_main.sas";		
	%end;
	
	%else %do;
	FILENAME TESTMAIL EMAIL TO = (&mailto.) 
							CC = (&mailcc.) 
							FROM=&mailfrom.			
	SUBJECT = "Weekly Report (Automated Message)";			
	DATA _NULL_;			
    	FILE TESTMAIL;			
    	PUT "Hi &username.,";			
    	PUT " ";			
    	PUT "No input file in &sharepath./INPUT/&filename..xlsx ";			
    	PUT "Extraction is aborted.";	
    	PUT " ";			
    	PUT "Thanks and regards,";			
    	PUT "xx";			
	RUN;
	
	%end;
	
%mend;
%findfile;