Hi, I am trying to create emails based on a distribution list that I have. I cannot get it to work! I have a work.distributionlist dataset with three columns: one with email addresses one with the report that the end user receives and one autonumber column. I would like to send an email that says " "emailaddress1" you receive "report1" " with the email address and report autopopulated by the dataset file. I need it to then loop and send the same email to emailaddress2 and emailaddress3, etc... I tried creating a macro, but I'm not very good at this and can't figure out how to do it. Help would be appreciated! Here's my code so far (I'm in SAS 9.4): *Create macro for looping;
%macro createdistro_lists;
%do autonumber = 1 %to 5;
%global email&autonumber.var;
%global report&autonumber.var;
*store distribution lists to a variable;
proc sql noprint; select trimn(email_address) into: email&autonumber.var from work.distribution_list;
run;
proc sql noprint; select trimn(report_received) into: report&autonumber.var from work.distribution_list;
run;
%put email&autonumber. = &&main&autonumber._var;
%put report&autonumber. = &&report_&autonumber._var;
%end;
%mend; %create_distro_lists;
*Send emails;
filename sendmail email; data null;
file sendmail to=("&email&autonumber.")
PUT "Hello"; put ' ';
put " We have noted that you receive the following reports.
Please confirm that this report is still in use.
Unused reports will be retired.";
put ' '; PUT "&report&autonumber.";
PUT " "; PUT "Regards,";
run;
... View more