Creating Separate log files for each iteration

[Ramya2]

Hi All,

Greetings for the Day..!!!

I have below set of datasets

Enrollment:

111

222

333

444

555

666

777

888

999

000

Where Enrollment is a Base for all demog and ipadmin datsets

demog:

111 ramya

222 prathic

777 pavan

444 stephan

555 ram

666 kavb

888 tiny

999 donn

000 raky

ipadmin:

111 ramya

111 ravi

111 Karan

222 nicole

222 sipho

222 cheryl

222 yong

222 asturd

Now I want from enrollemnt ,3 subjects to be picked each time. and  the subsequent demog and ipadmin also should run. with a separate log and sleeping time of 1 mints in each iteration.

Output is :

1st oteration:

demog:

111 ramya

222 prathic

ipadmin:

111 ramya

111 ravi

111 Karan

222 nicole

222 sipho

222 cheryl

222 yong

222 asturd

CREATE LOG AND SLEEP 1 MINUTES

2nd iteration:

demog:

444 stephan

555 ram

666 kavb

ipadmin:

"No matching subject to print"

CREATE  LOG AND SLEEP 1 MINUTES

Please help me.

Note: this is just an requiremnt draft , Where I need to impliment mmy logic. In my code the subjects and the data are huge. So created an example.

[Ramya2]

and iteration should continue till it reaches enrollment "000"

[ChrisNZ]

> Now I want from enrollemnt ,3 subjects to be picked each time

I don't see the 3 subjects

[Ramya2]

First 3 subjects. that is 111,222,333

[Quentin]

Did my answer to your question a couple days ago help, with an approach to log splitting?  

https://communities.sas.com/t5/SAS-Programming/Splitting-log-and-executing-a-set-of-subjects-togethe...

I don't think this new question is clear enough for me to add much more.  

[Patrick]

@Ramya2 

Looks to me @Quentin provided you already with an approach. ....but why would you do that in first place? In case something goes wrong in one of the iterations then you'd have to find the appropriate log to investigate. That's going to make debugging really hard.

If you have SAS/Connect licensed then an alternative would be to run child processes (rsubmit) per group. This would allow to have separate logs per execution but also have a collective log which gives you sufficient information about the whole process.