its given an error proc sql; SELECT count(DISTINCT ID) into :numPeople FROM MAGAZA_EXCEL; %let numPeople = &numPeople; quit; proc sql; SELECT DISTINCT ID into :ID - :ID&numPeople, :mail - :mail&numPeople FROM MAGAZA_EXCEL; quit; %macro send_report_emails(); %do i=1 %to &numPeople; %let ID = &&ID&i; %let to = &&mail&i; options emailhost=("smtp.office365.com" port=xxx STARTTLS auth=login id="trreport@xxxx" pw="xxxxx") emailid="trreport@yrnet.com" emailpw="xxxxx"; filename mymail email "&to" SUBJECT = "Report Status" from="trreport@xxxx" content_type="application\xlsx" ; data _null_; put "The following reports are complete: &ca"; put "The following reports are complete: &debit"; run; %end; %mend send_report_emails; %send_report_emails;
... View more
