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

[Santt0sh]

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.

[Urban_Science]

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!

[Santt0sh]

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...

[Santt0sh · Accepted solution]

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