topic Re: to send emails to each user providing the details of the tasks assigned to them. in SAS Programming

to send emails to each user providing the details of the tasks assigned to them.

Santt0sh — Fri, 17 Aug 2018 15:16:20 GMT

Hi,

I am trying to create files for each user, which will have details of the task. I am unable to achieve this.

Please find the attached code and suggest me what can i do, in order to achieve the results. currently the code which i am using is giving me the result below.

Current output.

--------------------------------

2 tasks assigned to user1

taskid= AA1000123

2 tasks assigned to user1

taskid=aa10052346

I would need some input to achieve the desired results.

Desired Output.

--------------------------------

2 tasks assigned to user1

taskid= AA1000123

taskid=aa10052346

PFA the sas code i am using.

Re: to send emails to each user providing the details of the tasks assigned to them.

Urban_Science — Fri, 17 Aug 2018 16:47:02 GMT

I think all that you need to do is add an IF statement to only output "2 tasks assigned to user1" only when printing the first taskid.

%IF &i = 1 %THEN %DO;
     %PUT RECORDS ====>> &&RC&i.;
     %PUT "************************&&RC&i. CASES ASSIGNED TO &&USRid&i.*****************";
%END;
%PUT "************************&&tsID1&i.*****************";

Let me know if that helps!

Re: to send emails to each user providing the details of the tasks assigned to them.

Santt0sh — Fri, 17 Aug 2018 18:01:42 GMT

Hi,

Thank you for your quick response.

Unfortunately the solution you have provided doesn't work as expected.

The If condition will not be true, hence the results are not changed.

Regards...

Re: to send emails to each user providing the details of the tasks assigned to them.

Santt0sh — Wed, 05 Sep 2018 18:43:51 GMT

Thank you for all your help, I have figured it out to send emails for each user.