DATA Step, Macro, Functions and more

Sending Emails to users with filenames

Reply
Contributor
Posts: 52

Sending Emails to users with filenames

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 ?

Frequent Contributor
Posts: 79

Re: Sending Emails to users with filenames

Posted in reply to yashpande

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;

 


Cheers from India!

Manjeet
Ask a Question
Discussion stats
  • 1 reply
  • 153 views
  • 0 likes
  • 2 in conversation