Hello
I keep getting the error in the subject on this question, is it because a lecrl needs to be added? I was thinking somewhere in the attache statement
%macro step2 ;
%if %sysfunc(fileexist(&Sasdatapath./ons_mcp_nps_annual_&Fldt..sas7bdat)) or
%sysfunc(fileexist(&Sasdatapath./ons_mcp_nps_closure_&Fldt..sas7bdat)) %then %do ;
filename mymail email "&emailprog."
cc = "&emailba."
subject = "ONS/MCP NPS BIWEEKLY PROCESS COMPLETE FOR &Fldt. - DELIVER FILES TO CLIENT"
attach = (
%if %sysfunc(fileexist(&Sasdatapath./ons_mcp_nps_annual_&Fldt..sas7bdat )) %then %do ;
"&Sasdatapath./ons_mcp_nps_annual_&Fldt..sas7bdat"
%end ;
%if %sysfunc(fileexist(&Sasdatapath./ons_mcp_nps_closure_&Fldt..sas7bdat )) %then %do ;
"&Sasdatapath./ons_mcp_nps_closure_&Fldt..sas7bdat"
%end 😉 ;
run ;
My guess would be that you need to include a space between the two attachments.
Art, CEO, AnalystFinder.com
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.