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
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.