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
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.