Does the first job take longer than 5 minutes?  Why not just change the schedule to run them further apart. ... View more

AllSoEasy: I don't think you got the message.  You didn't have an apostrophe in the comment you showed and, if if you did, the /*  */ type of comment would not have been bothered by it. You likely have a different problem, like an embedded apostrophe in one of the other not recommended (for a macro) comment types, or an incomplete set of /* */ comments. I would suggest changing all of your comments to the /*  */ type, leave the questioned comment in your code and make sure that the code runs.  Otherwise, you risk the possibility that an essential line of code is being ignored. ... View more

Looks like you all set, but here is another solution: /* If you already have a data set with all the country names then you don't need this data step */ /* Just use your countries data set in the proc sql step. */ /* Otherwise, create a data set with all of your countries */ data countries; country='argentina';output; country='abudhabi';output; run; proc sql noprint; select count(*)    into :countries    from countries ; quit; %macro x; %do i=1 %to &countries.; proc sql noprint;   select country     into :country     from countries (firstobs=&i. obs=&i.)   ; quit; %let country=%trim(%left(&country.)); /* You probably won't need this data step, I did just to make the code work */ data &country.;   country="&country."; run; data   %do j=1 %to 31;   work.&country.&j.   %end; ;   set &country.; run; %end; %mend x; %x; ... View more