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

tekish · Posted 12-14-2016 02:10 PM

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,

ChrisNZ · Posted 12-14-2016 05:47 PM

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;

High-Performance SAS Coding - Third Edition

View solution in original post

ChrisNZ · Posted 12-14-2016 05:47 PM

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;

High-Performance SAS Coding - Third Edition

tekish · Posted 12-20-2016 10:04 AM

Thanks ChrisNZ .

ChrisNZ · Posted 07-18-2018 07:46 PM

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.

High-Performance SAS Coding - Third Edition

ChrisNZ · Posted 07-19-2018 05:12 PM

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?

High-Performance SAS Coding - Third Edition

ChrisNZ · Posted 07-22-2018 06:28 PM

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.

High-Performance SAS Coding - Third Edition

ChrisNZ · Posted 07-22-2018 10:51 PM

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;

High-Performance SAS Coding - Third Edition

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

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

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

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

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

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

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

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

SAS Innovate 2025: Save the Date

SAS Training: Just a Click Away