topic Re: how to customize the send mails personalization for each person, code is below , please anyone in SAS Programming

how to customize the send mails personalization for each person, code is below , please anyone help

sas_university — Thu, 24 Nov 2022 07:57:48 GMT

how to customize the send mails personalization for each person, code is below , please anyone help on this .Where

-where we make changes on my code

-Customize for each person send message

EMP_ID	EMP_NAME	GENDER	BIRTHDAY	COMPANY	DESIGN	LOC	MAIL_ID
100	VENKATA	MALE	24/11/22	SAMA	DIRECTOR	PUNE	ravindranadh2125@gmail.com
101	MURALI	MALE	24/11/22	SAMA	DEVELOPER	PUNE	ravindranadh2125@gmail.com
102	PRABHAKAR	MALE	24/11/22	SAMA	DOMAIN	BANG	ravindranadh2125@gmail.com
103	PRASANNA	FEMALE	24/11/22	INFOTECH	PROGRAMMER	HYD	ravindranadh2125@gmail.com
104	RAMYA	FEMALE	26/11/22	GOOGLE	DEVELOPER	KOCHI	ravindranadh2125@gmail.com
105	MOUNIKA	FEMALE	23/11/22	MICROSOFT	PROGRAMMER	CHENNAI	ravindranadh2125@gmail.com
106	KIRAN	MALE	26/11/22	ACCENTURE	ANALYST	BANG	ravindranadh2125@gmail.com
107	NIKIL	MALE	25/11/22	WIPRO	DEVELOPER	MUMBAI	ravindranadh2125@gmail.com
108	MANOHAR	MALE	24/11/22	CYIENT	PROGRAMMER	HYD	ravindranadh2125@gmail.com
109	RAVINDRA	MALE	26/11/22	INFOSIS	ANALYST	PUNE	ravindranadh2125@gmail.com
110	PAVAN	MALE	25/11/22	SAMA	PROGRAMMER	CHENNAI	ravindranadh2125@gmail.com
111	RAMANI	FEMALE	24/11/22	ELI LILLY	DEVELOPER	KOCHI	ravindranadh2125@gmail.com

options unbuflog;
proc import datafile="/home/u61914035/import files/birthdayXL.xlsx"
dbms=xlsx
out=ds
replace;
run;
data staff;
set ds;
informat BIRTHDAY ddmmyy10.;
format BIRTHDAY date9.;
where BIRTHDAY ne .;
todays=put(today(),date9.);
run;

data bday_today;
set staff;
bday=substr(put(BIRTHDAY,date9.),1,5);
tday=upcase(substr(todays,1,5));
if bday=tday;
run;

proc sql;
select count(distinct MAIL_ID) into :emailcnt from bday_today;
%let emailcnt = %cmpres(&emailcnt);
select distinct MAIL_ID into :email1 - :email&emailcnt from bday_today;
quit;

%macro mail;
%if &emailcnt gt 0 %then
%do i = 1 %to &emailcnt;
filename Myemail email
from = "ravindranadh044@gmail.com"
subject = "!!! BIRTHDAY ALERT !!!"
attach=("/home/u61914035/import files/0d01cc9cebe2e8de8b60d8fbf6ee47bc.gif")
to = "&&email&i"
type = "text/html";

data null;
file Myemail;
set bday_today(where = (MAIL_ID="&&email&i"));
put 'HAPPY BIRTHDAY' ;
RUN;
%end;
%mend;
%mail;

how to customize the text or document through mail to each persons who have bdays automatically

sas_university — Thu, 24 Nov 2022 07:49:25 GMT

how to customize the text or document through mail to each persons who have bdays automatically without running the program daily...

EMP_ID	EMP_NAME	GENDER	BIRTHDAY	COMPANY	DESIGN	LOC	MAIL_ID
100	VENKATA	MALE	24/11/22	SAMA	DIRECTOR	PUNE	ravindranadh2125@gmail.com
101	MURALI	MALE	24/11/22	SAMA	DEVELOPER	PUNE	ravindranadh2125@gmail.com
102	PRABHAKAR	MALE	24/11/22	SAMA	DOMAIN	BANG	ravindranadh2125@gmail.com
103	PRASANNA	FEMALE	24/11/22	INFOTECH	PROGRAMMER	HYD	ravindranadh2125@gmail.com
104	RAMYA	FEMALE	26/11/22	GOOGLE	DEVELOPER	KOCHI	ravindranadh2125@gmail.com
105	MOUNIKA	FEMALE	23/11/22	MICROSOFT	PROGRAMMER	CHENNAI	ravindranadh2125@gmail.com
106	KIRAN	MALE	26/11/22	ACCENTURE	ANALYST	BANG	ravindranadh2125@gmail.com
107	NIKIL	MALE	25/11/22	WIPRO	DEVELOPER	MUMBAI	ravindranadh2125@gmail.com
108	MANOHAR	MALE	24/11/22	CYIENT	PROGRAMMER	HYD	ravindranadh2125@gmail.com
109	RAVINDRA	MALE	26/11/22	INFOSIS	ANALYST	PUNE	ravindranadh2125@gmail.com
110	PAVAN	MALE	25/11/22	SAMA	PROGRAMMER	CHENNAI	ravindranadh2125@gmail.com
111	RAMANI	FEMALE	24/11/22	ELI LILLY	DEVELOPER	KOCHI	ravindranadh2125@gmail.com

data bday_today;
set staff;
bday=substr(put(BIRTHDAY,date9.),1,5);
tday=upcase(substr(todays,1,5));
if bday=tday;
run;

proc sql;
select count(distinct MAIL_ID) into :emailcnt from bday_today;
%let emailcnt = %cmpres(&emailcnt);
select distinct MAIL_ID into :email1 - :email&emailcnt from bday_today;
quit;

data null;
file Myemail;
set bday_today(where = (MAIL_ID="&&email&i"));
put 'HAPPY BIRTHDAY' ;
RUN;
%end;
%mend;
%mail;

Re: how to customize the send mails personalization for each person, code is below , please anyone

andreas_lds — Thu, 24 Nov 2022 08:14:57 GMT

Please don't post questions multiple times.

Please post data in usable form: a data step using datalines.

When posting code, please use "insert sas code" (the button with the running person) and post properly formatted code only.

Form your description i don't understand what you want to achieve.

Re: how to customize the send mails personalization for each person, code is below , please anyone

sas_university — Thu, 24 Nov 2022 08:48:49 GMT

proc import datafile="/home/u61914035/import files/birthdayXL.xlsx"
dbms=xlsx
out=ds
replace;
run;
data staff;
set ds;
informat BIRTHDAY ddmmyy10.;
format BIRTHDAY date9.;
where BIRTHDAY ne .;
todays=put(today(),date9.);
run;

data bday_today;
set staff;
bday=substr(put(BIRTHDAY,date9.),1,5);
tday=upcase(substr(todays,1,5));
if bday=tday;
run;

 

proc sql;
select count(distinct MAIL_ID) into :emailcnt from bday_today;
%let emailcnt = %cmpres(&emailcnt);
select distinct MAIL_ID into :email1 - :email&emailcnt from bday_today;
quit;

%macro mail;
%if &emailcnt gt 0 %then
%do i = 1 %to &emailcnt;
filename Myemail email
from = "ravindranadh044@gmail.com"
subject = "!!! BIRTHDAY ALERT !!!"
attach=("/home/u61914035/import files/0d01cc9cebe2e8de8b60d8fbf6ee47bc.gif")
to = "&&email&i"
type = "text/html";

data null;
file Myemail;
set bday_today(where = (MAIL_ID="&&email&i"));
put 'HAPPY BIRTHDAY' ;
RUN;
%end;
%mend;
%mail;

Sorry for post twice,

1.how to customize a mail for each Pearson

2.how to customize the text or document through mail to each persons who have bdays automatically

Re: how to customize the send mails personalization for each person, code is below , please anyone

Kurt_Bremser — Thu, 24 Nov 2022 16:54:21 GMT

All mail_id seem to be identical, so you would only send one email anyway.

Re: how to customize the send mails personalization for each person, code is below , please anyone

sas_university — Thu, 24 Nov 2022 17:34:58 GMT

only one mail given for example

Re: how to customize the send mails personalization for each person, code is below , please anyone

Kurt_Bremser — Thu, 24 Nov 2022 17:50:26 GMT

Simple approach:

Create a macro which sends one email to one person. It should accept the email address as parameter.

Then read yor initial dataset, and for every observation where day(birthday) = day(today()) and month(birthday) = month(today()) call the macro with CALL EXECUTE.

Re: how to customize the send mails personalization for each person, code is below , please anyone

sas_university — Fri, 25 Nov 2022 03:48:58 GMT

how to customise text to different persons...

Re: how to customize the send mails personalization for each person, code is below , please anyone

sas_university — Fri, 25 Nov 2022 06:32:07 GMT

@PeterClemmensen

Please look into this problem

Re: how to customize the send mails personalization for each person, code is below , please anyone

Kurt_Bremser — Fri, 25 Nov 2022 06:52:28 GMT

Define "customize". Show examples of the text for different persons. Provide example data supplying the items for customization.

For code, provide example data in a data step with datalines. DO NOT SKIP THIS.

Re: how to customize the send mails personalization for each person, code is below , please anyone

sas_university — Fri, 25 Nov 2022 07:34:45 GMT

data ds;

infile datalines;

input EMP_ID EMP_NAME$ GENDER$ BIRTHDAY COMPANY$ DESIGN$ LOC $ MAIL_ID$ 1 -26;

cards;

100 venkata male 27/11/2022 sama director pune ravindranadh2125@gmail.com

101 murali male 28/11/2022 sama teamlead pune ravindranadh2125@gmail.com

102 prabhkar male 27/11/2022 sama manager pune ravindranadh2125@gmail.com

103 prasanna female 27/11/2022 infotech juniordev hyd ravindranadh2125@gmail.com

104 ramya female 27/11/2022 infotech juniordev chennai ravindranadh2125@gmail.com

105 mounika female 28/11/2022 google juniordev hyd ravindranadh2125@gmail.com

106 kiran male 29/11/2022 google juniordev hyd ravindranadh2125@gmail.com

107 nikhil male 28/11/2022 cyient juniordev bang ravindranadh2125@gmail.com

108 manohar male 28/11/2022 infosis juniordev bang ravindranadh2125@gmail.com

109 ravindra male 27/11/2022 infosis juniordev hyd ravindranadh2125@gmail.com

110 pavan male 27/11/2022 sama juniordev pune ravindranadh2125@gmail.com

111 ramani male 27/11/2022 eli llily juniordev vizag ravindranadh2125@gmail.com

;

run;

proc import datafile="/home/u61914035/import files/birthdayXL.xlsx"
dbms=xlsx
out=ds
replace;
run;
data staff;
set ds;
informat BIRTHDAY ddmmyy10.;
format BIRTHDAY date9.;
where BIRTHDAY ne .;
todays=put(today(),date9.);
run;

data bday_today;
set staff;
bday=substr(put(BIRTHDAY,date9.),1,5);
tday=upcase(substr(todays,1,5));
if bday=tday;
run;

 

proc sql;
select count(distinct MAIL_ID) into :emailcnt from bday_today;
%let emailcnt = %cmpres(&emailcnt);
select distinct MAIL_ID into :email1 - :email&emailcnt from bday_today;
quit;

%macro mail;
%if &emailcnt gt 0 %then
%do i = 1 %to &emailcnt;
filename Myemail email
from = "ravindranadh044@gmail.com"
subject = "!!! BIRTHDAY ALERT !!!"
attach=("/home/u61914035/import files/0d01cc9cebe2e8de8b60d8fbf6ee47bc.gif")
to = "&&email&i"
type = "text/html";

data null;
file Myemail;
set bday_today(where = (MAIL_ID="&&email&i"));
put 'HAPPY BIRTHDAY' ;
RUN;
%end;
%mend;
%mail;

Re: how to customize the send mails personalization for each person, code is below , please anyone

Kurt_Bremser — Fri, 25 Nov 2022 07:52:16 GMT

Your code will send identical mails to all recipients, there is no customization.

Show examples for the mails you want.

Re: how to customize the send mails personalization for each person, code is below , please anyone

sas_university — Fri, 25 Nov 2022 09:03:58 GMT

career.clinica@gmail.com

ravindranadhchowdari@gmail.com

ravindranadh044@gmail.com

klpn.2000@gmail.com

ravalaramya1998@gmail.com

mounikarajkumar25@gmail.com

kiran.nallagulla@gmail.com

nikhilyallamandala1997@gmail.com

pathipati778@gmail.com

ravindranadh2125@gmail.com

yedumbakulapavam@gmail.com

srilakshmiramani5@gmail.com

Re: how to customize the send mails personalization for each person, code is below , please anyone

Kurt_Bremser — Fri, 25 Nov 2022 15:24:39 GMT

So the only thing that changes is the recipient?

Re: how to customize the send mails personalization for each person, code is below , please anyone

sas_university — Fri, 25 Nov 2022 18:26:58 GMT

@Kurt_Bremser yes

Re: how to customize the send mails personalization for each person, code is below , please anyone

Kurt_Bremser — Fri, 25 Nov 2022 19:06:20 GMT

Then I have already given you what to do:

Create a macro which sends one email to one person. It should accept the email address as parameter.

Then read yor initial dataset, and for every observation where day(birthday) = day(today()) and month(birthday) = month(today()) call the macro with CALL EXECUTE.