Hi All,
My question is related to send emails to users. I have a data set user_details which has variable user_name and another dataset file_details which has list of big files (over 10gb )against those users. I need to send emails to all of them asking to delete unnecessary files.
Sample user_details table :
User_name
L01234
M09677
Sample file_details:
User_name File_name Size
L01234 c:\test1.txt 12
L01234 c:\test2.txt 11
M09677 d:\sample1.txt 34
M09677 d:\ sample2.txt 17
So I need to send emails to users L01234 and M09677. Email should be something like
Hi L01234,
Please delete unnecessary files.
You may look at following files:
C:\test1.txt
C:\test2.txt
Similar mail should be sent to user M09677
Any ideas on how to accomplish this ?
Hi,
You can use the below sample code to send emails to the users, first we set your input dataset, lets call it -' have', the code will create a script in temp loation named(email_snd), which will be called using %inc and email will be sent based on data provided in the have data-set.
filename email_snd temp; data _NULL_; set have; /*put you input dataset name here*/ length rec1 $50. rec2 $50. rec3 $30. rec4 $30. rec5 $30. rec6 $30. rec7 $30.; rec1 = %nrstr("filename mymail email '#email_id#@site.com' subject='Delete Big Files';"); rec1 = tranwrd(rec1, '#email_id#', User_name); rec2 = %nrstr("data _null_;"); rec3 = %nrstr("file mymail;"); rec4 = %nrstr("put 'Hi #usr_id#';"); rec4 = tranwrd(rec4, '#usr_id#',User_name); rec5 = %nrstr("put 'Please delete unnecessary files.';"); rec6 = %nrstr("put 'You may look at following files:';"); rec7 = %nrstr("put '#file_name#' ;"); rec7= tranwrd(rec7, '#file_name#', File_name); file email_snd; put rec1 / rec2 / rec3 / rec4 / rec5 / rec6 / rec7; run; %inc email_snd; run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.