Dear Team,
I have a data set and what to sent rm wise mail. sample data attached for your reference. (outlook)
for example
To :- tarun.p.sharma@gmail,com
CC :- deepak2@gmail.com
Body Messasge
Dear Mr/Ms Tarun
********************
Regards
Tarun Kumar
With Below attached data
cust_id
cust_name
AUM
LI
MF
GI
RM_ID
RM_EMAIL
RM2_EMAIL
10002
Tarun
1000
1
3
1
8126
tarun.p.sharma@gmail.com
deepak2@gmail.com
10003
Ramesh
5000
1
4
1
8126
tarun.p.sharma@gmail.com
deepak2@gmail.com
10004
Suresh
4000
2
2
2
8126
tarun.p.sharma@gmail.com
deepak2@gmail.com
10013
Suresh
4000
1
22
3
8126
tarun.p.sharma@gmail.com
deepak2@gmail.com
10014
Kavita
9000
1
4
3
8126
tarun.p.sharma@gmail.com
deepak2@gmail.com
10015
vaishali
1000
1
5
3
8126
tarun.p.sharma@gmail.com
deepak2@gmail.com
... View more
data have; input custname:$15.; datalines; Nichols,KregFI Reddy,RamanaBT ;run;
data want; set have; first_name = substr(scan(custname,-1,','),1,length(scan(custname,-1,','))-2); run;
... View more
Hi Dhruv,
use intck function to calculated no of days or no of month between tow transaction date.
no_of_day = intck("days",'01jan18'd,'01apr18'd) ---> will show the no of days
no_of_day = intck("MONTH",'01jan18'd,'01apr18'd) ----> will show the no of month
... View more
data have; input product_name$40.; datalines; LIMCEE TABLET CELINTABLET AMOXYCLAV CAP RECLIMET OD TAB GLYCOMET SR TAB REFRESH TEARS WELL WOMEN CAPSULE RENERVECAPSULE MET XL TABLET MET XL AM TABLET SHELCAL SHELCAL HD SHELCAL HD12 TENCLIMET TABLET ZITAMET PLUS TABLET PREGAB M CAP LOSAR H40 TABLET LOSAR H80 TAB PRAZOPRESS XL 25 TABLET ; run;
data want; set have; if index(product_name,"TABLET") then Remark = 'INFO_TAB'; else if index(product_name,"TAB") then Remark = 'INFO_TAB'; else if index(product_name,"CAP") then Remark = 'INFO_CAP'; else if index(product_name,"CAPSULE") then Remark = 'INFO_CAP';
RUN;
... View more
data have; input id1 id2; datalines; 1001 10 1001 10 1001 11 1001 10 1002 12 1002 12 1002 13 ; RUN;
proc sort data = have; by id1 id2; run;
data want; set have; by id1 id2; if first.id1 then first_unique = 1; else first_unique = 0; run;
OR
if yo want to extract the unique data then pls use below code ;
proc sort data = have OUT= WANT NODUP;BY ID1; run;
... View more
