topic Re: How to add macro values in email body in SAS Programming

How to add macro values in email body

saswiki — Mon, 06 Mar 2023 03:45:57 GMT

Hi Experts,

I have a scenario where i have to add the table values as email body but i am not able to do it for multiple lines.

Here is the SAS dummy program.

data test;
infile datalines;
input part $ bldg $ area $ po $;
datalines;
A1 FR KIT XX1
A2 W KIT XX1
A3 FR LOIN XX4
C3 FR KIT XX6
;
run;

and the email body should be : This can be n number of observations. Can anyone help me to get this looped.

A1 is routed to FR KIT but does not have a coordinate on XX1.Determine the correct coordinate and add it.
A2 is routed to W KIT but does not have a coordinate on XX1.Determine the correct coordinate and add it.
A3 is routed to FR LOIN but does not have a coordinate on XX4.Determine the correct coordinate and add it.
C3 is routed to FR KIT but does not have a coordinate on XX6.Determine the correct coordinate and add it.

Re: How to add macro values in email body

Patrick — Mon, 06 Mar 2023 05:49:33 GMT

Can you please share your current code that creates the email.

Re: How to add macro values in email body

saswiki — Mon, 06 Mar 2023 09:38:19 GMT

I am not sure how to loop the macro values,

The below code i tried but it reads only first value in the macro.

data test;
infile datalines;
input part $ bldg $ area $ po $;
datalines;
A1 FR KIT XX1
A2 W KIT XX1
A3 FR LOIN XX4
C3 FR KIT XX6
;
run;

proc sql;
select part into: part_list from test;
quit;

proc sql;
select bldg into: bldg_list from test;
quit;

proc sql;
select area into: area_list from test;
quit;

proc sql;
select po into: po_list from test;
quit;

%put &date.;
OPTIONS EMAILSYS=SMTP EMAILHOST=intramail.cis.cat.com EMAILID="test@mail.com";
FILENAME BLAT EMAIL
FROM = ( "test@mail.com" )
TO = ("rec@mail.com" )
SUBJECT = ("&subject.– &date")
TYPE = "TEXT/HTML"

;
DATA _NULL_;
FILE BLAT;
put "Team, ";
PUT "&part_list. is routed to &bldg_list. &area_list but does not have a coordinate on &po_list..Determine the correct coordinate and add it.
 ";
PUT " ";
PUT "Regards, ";
RUN;

Re: How to add macro values in email body

s_lassen — Mon, 06 Mar 2023 10:29:27 GMT

I do not think you should loop the macro variables for the email content, just read the data, something like this:

DATA _NULL_;
FILE BLAT;
set test end=done:
if _N_=1 then 
  put "Team,<BR><BR>";
PUT part "is routed to " bldg. area "but does not have a coordinate on " po ". Determine the correct coordinate and add it. <BR>";
if done;
PUT "<BR><BR>";
PUT "Regards,<BR><BR>";
RUN;