topic Re: Creating Separate log files for each iteration in SAS Programming

Creating Separate log files for each iteration

Ramya2 — Sun, 03 Feb 2019 12:14:20 GMT

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.

Re: Creating Separate log files for each iteration

Ramya2 — Sun, 03 Feb 2019 12:15:35 GMT

and iteration should continue till it reaches enrollment "000"

Re: Creating Separate log files for each iteration

ChrisNZ — Sun, 03 Feb 2019 22:24:17 GMT

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

I don't see the 3 subjects

Re: Creating Separate log files for each iteration

Quentin — Sun, 03 Feb 2019 22:31:19 GMT

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-together/m-p/531624/highlight/true#M145543

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

Re: Creating Separate log files for each iteration

Patrick — Sun, 03 Feb 2019 23:16:14 GMT

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

Re: Creating Separate log files for each iteration

Ramya2 — Mon, 04 Feb 2019 01:01:32 GMT

First 3 subjects. that is 111,222,333