How to create table inside the order list

tekish — Wed, 01 Feb 2017 20:42:23 GMT

Dear experts,

I want to create an automated email with different table inside the order list.

here is the sample output.

Subject: list of variable from Sashelp

Dear [ Name]:

Name of student from sashelp.
List of student below with age eleven.

Name	Sex	age	Height	Weight
Joyce	F	11	51.3	50.5
Thomas	M	11	57.5	85

3.List of student below with age eleven.

Name	Sex	age	Height	Weight
Joyce	F	11	51.3	50.5
Thomas	M	11	57.5	85

Thank you for you for helping .

here is the sample SAS codes.

data class;

set sashelp.class;

run;

PROC SORT DATA=CLASS;

BY AGE;

RUN;

%MACRO test(FLD,RECIPIENT_EMAIL,RECIPIENT_NAME,LEVEL);

FILENAME MYMAIL EMAIL

TO = "emailadderess@test1.com"

FROM = "emailadderess@test1.com"

SENDER = "emailadderess@test1.com"

REPLYTO = "emailadderess@test1.com"

BCC = "emailadderess@test1.com"

CT = "TEXT/HTML";

DATA TEMP;

SET class;

BY age;

IF (&FLD = "&LEVEL");

RUN;

DATA _NULL_;

FILE MYMAIL;

SET TEMP END = EOF;

IF _N_ = 1 THEN DO;

%LET RECIPIENT_NAME=Name of the person;

/*TO = "&RECIPIENT_EMAIL";*/

TO = "emailadderess@test1.com";

PUT '!EM_TO! ' TO;

PUT '!EM_SUBJ! ' "list of variable from Sashelp &LEVEL";

PUT '<html><body>';

PUT "Dear &RECIPIENT_NAME;";

PUT '';

PUT "";

PUT "<ol><li>Select Name of student from sashelp</li>";

PUT "<li>list of student below with age 11 section. </li>";

PUT '';

PUT '<table border = 1>';

PUT '<tr>';

PUT '<td>Name</td>';

PUT '<td>sex</td>';

PUT '<td>age</td>';

PUT '<td>height</td>';

PUT '<td>weight</td>';

PUT '</tr>';

END;

PUT '<tr>';

PUT '<td>' Name '</td>';

IF sex=M THEN

PUT '<td> ' sex '</td>';

ELSE PUT '<td>' sex '</td>';

IF age=14 THEN

PUT '<td> ' age '</td>';

ELSE PUT '<td>' age '</td>';

IF height>10 THEN

PUT '<td> ' height '</td>';

ELSE PUT '<td>' height '</td>';

IF weight<30 THEN

PUT '<td> ' weight '</td>';

ELSE PUT '<td>' weight '</td>';

PUT '</ol>';

PUT '</tr>';

IF EOF THEN DO;

PUT '</table>';

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

END;

PUT "<li>list of student above with age 11 </li>";

PUT '</ol>';

PUT '</tr>';

PUT '<table border = 1>';

PUT '<tr>';

PUT '<td>Name</td>';

PUT '<td>sex</td>';

PUT '<td>age</td>';

PUT '<td>height</td>';

PUT '<td>weight</td>';

PUT '</tr>';

END;

PUT '<tr>';

PUT '<td>' Name '</td>';

IF sex=M THEN

PUT '<td> ' sex '</td>';

ELSE PUT '<td>' sex '</td>';

IF age=14 THEN

PUT '<td> ' age '</td>';

ELSE PUT '<td>' age '</td>';

IF height>10 THEN

PUT '<td> ' height '</td>';

ELSE PUT '<td>' height '</td>';

IF weight<30 THEN

PUT '<td> ' weight '</td>';

ELSE PUT '<td>' weight '</td>';

PUT '</ol>';

PUT '</tr>';

IF EOF THEN DO;

PUT '</table>';

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

END;

RUN;

FILENAME MYMAIL CLEAR;

%MEND test;

PROC SORT DATA=class OUT=DRIVER_AGE(KEEP=age) NODUPKEY;

BY age;

RUN;

DATA _NULL_;

SET DRIVER_AGE;

BY age;

IF age=11;

CALL EXECUTE('%test(AGE,'||RECIPIENT_EMAIL||','||RECIPIENT_NAME||','||AGE||')');

RUN;

Re: How to create table inside the order list

lakshmi_74 — Tue, 21 Mar 2017 16:29:48 GMT

In your point of view, Do you want to create a mail list to each student. Is it correct?

topic Re: How to create table inside the order list in SAS Programming

How to create table inside the order list

Re: How to create table inside the order list