11-05-2013 08:19 AM
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 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
Please delete unnecessary files.
You may look at following files:
Similar mail should be sent to user M09677
Any ideas on how to accomplish this ?
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@example.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;