topic Re: how to create an automated email with table and text contents. in SAS Programming

how to create an automated email with table and text contents.

tekish — Wed, 14 Dec 2016 19:10:38 GMT

Dear Sascommunity,

I am trying to create an email template with table and text. the table should be on the Top and followed by the Text.

Here is my sample output examples.

ID	ISO	NAME	ISONAME	region	pop
182	050	BANGLADESH	BANGLADESH	SEAR	141,822,276
200	064	BHUTAN	BHUTAN	SEAR	2,162,546
250	104	MYANMAR	MYANMAR	SEAR	50,519,492

Demographic analysis, the statistical description of human populations, is a tool used by government agencies, political parties, and manufacturers of consumer goods. Polls conducted on every topic imaginable, from age to toothpaste preference, give the government and corporations an idea of who the public is and what it needs and wants. The government's census, which is conducted every ten years, is the largest demographic survey of all. They must qualify as economically disadvantaged either by direct certification or a supplemental household survey. Today demographic is also being used as a noun; so, for example, TV advertisers are constantly worrying about how to appeal to the 18-to-24-year-old demographic.

Thank you,

the below is my sample codes.

proc sort data=sashelp.DEMOGRAPHICS out=email;

by region id;

run;

%MACRO EMAIL(region);

FILENAME MYMAIL EMAIL

TO = "tekish20@yahoo.com"

CC = "tekish20@yahoo.com"

SUBJECT = "DEMOGRAPHICS"

CT = "TEXT/HTML"

FROM = "tekish20@yahoo.com"

SENDER = "tekish20@yahoo.com"

REPLYTO = "tekish20@yahoo.com"

content_type="text/html";

DATA TEMP;

SET email;

BY region ID;

where region="&region";

RUN;

DATA _NULL_;

FILE MYMAIL;

SET TEMP END=EOF;

IF _N_=1 THEN DO;

%IF &TESTING = Y %THEN %DO;

temail = "tekish20@yahoo.com";

semail = "tekish20@yahoo.com";

%END;

PUT '!EM_TO! ' temail;

PUT '!EM_CC! ("' semail '")';

PUT '<html><body>';

PUT "Dear ";

PUT "";

PUT "";

PUT '<table border = 1>';

PUT '<tr>';

PUT '<td>ID</td>';

PUT '<td>ISO</td>';

PUT '<td>NAME</td>';

PUT '<td>ISONAME</td>';

PUT '<td>region</td>';

PUT '<td>pop</td>';

PUT '</tr>';

END;

PUT '<tr>';

PUT '<td>' ID '</td>';

PUT '<td>' ISO '</td>';

PUT '<td>' NAME '</td>';

PUT '<td>' ISONAME '</td>';

PUT '<td>' region '</td>';

PUT '<td>' pop '</td>';

PUT '</tr>';

IF EOF THEN DO;

PUT '</table>';

PUT '</body></html>';

END;

PUT "";

PUT "";

PUT "<TD>";

PUT "Demographic analysis, the statistical description of human populations, is a tool used by";

PUT "government agencies, political parties, and manufacturers of consumer goods. Polls conducted ";

PUT "on every topic imaginable, from age to toothpaste preference, give the government and";

PUT "corporations an idea of who the public is and what it needs and wants. The government's";

PUT "census, which is conducted every ten years, is the largest demographic survey of all.";

PUT "They must qualify as economically disadvantaged either by direct certification or a supplemental household survey.";

PUT "Today demographic is also being used as a noun; so, for example, TV advertisers are constantly";

PUT "worrying about how to appeal to the 18-to-24-year-old demographic.";

PUT "";

PUT "";

PUT "";

PUT "Thank you,";

PUT "</TD>";

RUN;

FILENAME MYMAIL CLEAR;

%MEND EMAIL;

%let TESTING = Y;

proc sort data=email out=drivers(keep=region) nodupkey;

by region ;

run;

DATA _NULL_;

SET drivers;

BY region;

IF region='SEAR';

CALL EXECUTE('%EMAIL('||region||')');

RUN;

Thanks,

Re: how to create an automated email with table and text contents.

ChrisNZ — Wed, 14 Dec 2016 22:47:39 GMT

This works:


filename REPORT "%sysfunc(pathname(work))\test.html";
filename SEND email to           = "xxx"
                    subject      = "test"
                    from         = "xxx"
                    content_type = "text/html";


ods html file=REPORT;
proc print data=SASHELP.CLASS; run;
ods html close;

data _null_;
  infile REPORT;
  file SEND;
  input;
  if _infile_ ne '</html>' then put _infile_;
  else do;
    put '<p>More text</p></html>';
  end;
run;

Re: how to create an automated email with table and text contents.

tekish — Tue, 20 Dec 2016 15:04:48 GMT

Thanks ChrisNZ .

Re: how to create an automated email with table and text contents.

ChrisNZ — Wed, 18 Jul 2018 23:46:12 GMT

Something like this?


data _null_;
  infile REPORT;
  file SEND;
  input;
  if _infile_ ne '</html>' then put _infile_;
  else do;
    infile INFO end=OEF;
    do until EOF;
      input ;
      put _infile_;
    end;
    put '</html>';
  end;
run;

Sorry can't test, there may be errors, but that's the gist.

Re: how to create an automated email with table and text contents.

ChrisNZ — Thu, 19 Jul 2018 21:12:51 GMT

If you want the text at the top, why do you write it at the bottom?

</html> is the bottom of the document (looking for </body> would be better test actually).

And <body> is the start of the page.

Do you understand the code you are running?

Re: how to create an automated email with table and text contents.

ChrisNZ — Sun, 22 Jul 2018 22:28:05 GMT

The program modifies a HTML file to add more text. These files' structure is very simple. Look up the structure and you'll see what the issue is. You are adding text at the end of the file, so of course that text appears at the end.

Re: how to create an automated email with table and text contents.

ChrisNZ — Mon, 23 Jul 2018 02:51:11 GMT

Not too sure what more I could supply.

If you write you text when you find <body> you'll write at the top of the html page. Something like:

if _infile_ =: '<body' then do;
  ***write additional header*** (see my message #5 with   infile INFO end=OEF;  ) 
  put _infile_; 
end;