Hi SASers!
I'm not sure if this has been asked or not, I've read a few threads but haven't read what I'm looking for. What I'm looking to do is create an email thats sent out daily with information included within the email, not a table just information. For example I would like to put:
Mail is defined at the top of code as an email with a list of people to send the email and attachment with records. this is just an example but thats what I want. But as it stands I can't figure out how to have both the font options and the information being called in at the same time, only one or the other. I would really appreciate the help on this one.
Where InRec COMMA10 is a number of industry records and Negative COMMA10 is the unmatched records. Both these are called from a previous datastep
DATA _NULL_;
SET TEMP.Industry;
IF _N_ EQ 1 THEN DO;
ODS HTML BODY= mail;
file mail;
ods escapechar='^';
ODS HTML TEXT='<div>^S={fontsize=11pt font_weight=bold font_face="Courier New"
To Team,
<BR/><BR/>Industry records have arrived.
<BR/><BR/>A Total of :' InRec COMMA10. ' <BR/>records have been reconciled. There are' Negative COMMA8. '
unmatched records that should be investigated. ^S={}</div>'
ODS HTML CLOSE;
END;
ODS LISTING;
RUN;
Any Help would be very appreciated
Sorry I'm not sure what happened but the end of the text line that has a ^S={ was supposed to be the ending and be ^S={}</div>'
Try using the code editor to insert your code. The {i} icon or notepad icon at the top of the editor allow you to insert code. The forum will still garble some of it, so check it over though.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.