@Astounding, I have tried giving mod(&j,3)=1, But it is not coming as expected. Kindly find the details below. My total number of subjects:10 20314001003 20314001004 20314001005 20314001006 20314001007 20314001008 20314001011 20314001013 20314001014 20314001015 My caller macro; %macro caller(); %do j=1 %to &npts; %looper(subject=&&pt&j.); %if %sysfunc(mod(&j,3))=1 %then %do; proc printto new log ="/ctshared/cdr/dev/RAMYA/archive/logfile_&j..log"; run; %let rc=%sysfunc(sleep(60,1)); %end; %end; %mend caller(); %caller(); Log file details. Logfile_1.log - 2nd subject to 4th subject Logfile_4.log - 5th subject to 8th subject Logfile_7.log - 9th subject to 10th subject Logfile_10.log - no entry But, I want 1st to 3rd , 4th to 6th ,7th to 9th and 10th ... View more

Sorry, I am unable to find that icon. ... View more

what is this i window? ... View more

@ballordw, Here is my Looper macro, just before caller.. ***checking whether any new entry for the onsetdt rslt endptid****; /*data final_1; merge final (in=a) test.History (in=b); by _all_; if a and not b; run;*/ ******relpacing the history file with current one****; data test.history; set final; run; ******creating macro variable for site and subject to creat the output for each subject; data _NULL_; set final_1 end=eof; call symput('pt'||compress(put(_n_,best.)),trim(left(upcase(subject)))); if eof then call symput('npts',compress(put(_n_,best.))); run; ****creating macro variable to create or run the report conditionally******; %let count=0; data _null_ ; set final_1 end=eof NOBS=COUNT;; countc = put(count,best.); if _n_ = 1 then call symput('count',countc); run; %put &count; %macro new_entry; %if &count ne 0 %then %do; *****genrating the report and sent patient profile in attached the mail if new entry****; *****selecting the subject only who have value for the endptid,event and onsetdt*****; proc sql; create table demo as select * from demog_1_ where subject in (select subject from final_1) order by subject,site; quit; ********************** Create profile for each patient*******************; %macro looper(subject=,); options papersize = A4 orientation = landscape nodate center nonumber bottommargin = 0.25in topmargin = 0.25in leftmargin = 0.25in rightmargin = 0.25in ; ods listing close; /*ods pdf body = "/ctshared/cdr/prod/a423_20110203/AMG423_20110203_Patient_Profile/rms32763/AMG423_20110203_&subject._Patient Profile.pdf";*/ ods pdf body = "/ctshared/cdr/dev/RAMYA/AMG423_20110203_&subject._Patient Profile.pdf"; ods noresults; footnote2 justify=left height=0.5 "Report Creation Date/Time: &sysdate. &systime. AM PDT" ; footnote3 justify=left height=0.5 "For Internal Use Only. Amgen Confidential."; Title1 Bold "AMG423_20110203_&subject._Patient Profile"; Title4 italic justify=left "Demographics"; PROC REPORT DATA=demo NOWD split='*' ; where subject in ("&subject" "Subject"); column ("Demographics" site subject age_y_c sex svstdt_raw); define site / Center Display "Site" style=[cellwidth=15mm]; define subject / Center Display "Subject" style=[cellwidth=22mm]; define age_y_c / Center Display "Age" style=[cellwidth=20mm]; define sex / Center Display "Sex" style=[cellwidth=20mm]; define svstdt_raw / Center Display "Screening Date" style=[cellwidth=20mm]; run; ods PDF close; /* must close tagsets.ExcelXP here*/ ods listing; ods results; ods listing; %mend looper ; ... View more

@PaigeMiller I need to use MOD(3,&j)=0 because, I need to execute 3 outputs at a time. the above will create 1 output each with a execution break of 1 minutes. But need 3 outputs together needs to be creted with the execution break of 1 minutes. Suppose if I have 10 subjects. 3 should execute and sleep for 1 minutes. Next 4 to 6 should execute and sleep for 1 minutes. And so on. ... View more

@PaigeMiller Apologies, Posted the code with typo error. In Program I have used proper quotes. ... View more

@Patrick How do I create separate log files for the 3 pdfs which is creating in intervals? ... View more

Thanks for your quick response. It is working for me.From past 4 days I was struggling on this. This really helped me. Actually, I have around 6500 subjects for each of those pdf is getting created, to complete this execution it is taking 3 to 4 days and also it consumes high space disk. Around 5gb of log is getting created. So inorder to overcome this, I thought of splitting the executiion and once after a set of execution completes, A log will be moved to some shared location and current log will be cleared. So asked an help. Thank you. Much appreciate your time spent on this. ... View more

@Patrick Ok got it. Thank you. I have tried using the code which you have provided. It executes the for all the subjects without a gap. so I provided sleep(60,1), for between each of the subjects it will have a break of 1 minutes. So, I want 3 subjects to be executed in one shot and then sleep for minutes. The process should continue till the all the subjects executes. I think I have to provide another do inside caller macro right? kindly suggest the code. ... View more

Can you please explain what does that arguments inside sleep function for? ... View more

@Patrick Wow it is working absolutely fine. Thank you so much. ... View more

The above code is not working. pdf is getting created without a time gap. I am working on Enterprise guide version 7.1. ... View more

It is 5 minutes. ... View more