6924 /* 1) Reset */
6925 ods _all_ close;
6926 ods listing close;
194 The SAS System 13:20 Thursday, November 13, 2025
6927 ods results off;
6928 filename m clear;
WARNING: No logical assign for filename M.
Here is the code I run to send the email./****Send via Email**********/
/****Send via Email**********/
/****Send via Email**********/
proc sql noprint;
select put(max(Haamada_date),ddmmyy10.) as max_Haamada_date into : max_Haamada_date
from r_r.XXXPanel_xxxt_CS
;
quit;
/*%let TO_Email=("Ron.Einstein@BankLeumi.co.il");*/
/* 1) Reset */
ods _all_ close;
ods listing close;
ods results off;
filename m clear;
FILENAME m EMAIL
/*TO=&TO_Email.*/
TO="xxx.xxx@xxx.co.il"
FROM="xxx.xxx@xxx.co.il"
SUBJECT="xxxx-CS"
CONTENT_TYPE="text/html"
encoding="utf-8";
data _null_;
file m lrecl=32767;
put "פאנל חדש עודכן עד תאריך &max_Haamada_date. <br>";
put "<br>";
put "<br>";
put "<br>";
put "<br>";
put "<br>";
put "בברכה <br>";
put "xxx xxx <br>";
run;
You try to clear a file reference that does not exist. Remove the FILENAME CLEAR statement.
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.