About atesera

atesera · ‎12-18-2024

ok thanks for that. Yeah, I would like the program to stop even for those errors because sometimes I create those man-made errors to stop the program going further as it will mess up the rest of the datasets.

atesera · ‎12-18-2024

@SASKiwi @quickbluefish I think it is working now. I believe this option looks for system errors not errors created within the SAS query. The sample query that I was testing had a statement "if Product = '' then put 'ERROR: ' Plan;" and it didnt work for that ERROR but then I tested against a system or syntax error within the query and then it worked. I have to test a bit more but I guess I am confident now that was the case. Thanks for your help

atesera · ‎12-18-2024

well, now I am getting something different. I can see all the logs combined from the run SAS programs (1 & 2) and thats how I want however, this time although there are some ERRORs in the first program (programm #1) batch still continues to the next program (program #2). That's strange because when I first tested your solution it worked but doesn't work.

atesera · ‎12-18-2024

Thanks for that. It is working however, the problem I have now is that I could only see the log related with the last SAS program code within the batch. when the first two SAS programs (program #1.sas and program #2.sas) are completed I could only see the log related with the program #3.sas as it is the last program within the batch. But I need to see all the logs related with all 3 programs

atesera · ‎12-18-2024

Thanks for your advice. I asked SASKiwi for an example of that %INCLUDE solution and where to use it and how.

atesera · ‎12-18-2024

@SASKiwi thanks for your response. Could you please include an example of your solution for %INCLUDE. Where should I put that %INCLUDE statement? in the batch or in the SAS programs under the batch

atesera · ‎12-17-2024

Thanks for this. So where do I place my regular SAS query in this program? And why the ** ... and this at the end ; %startstop(beginning=0, lib=<YOUR LIBREF>); has (begining=0, ) at the end? shouldnt this be a different number as we used =0 at the beginning for Program #1?

atesera · ‎12-17-2024

they start with a trigger email or sometimes I manually start the batch. I don't use Task Scheduler.

atesera · ‎12-17-2024

Yes, correct. So, below is the screenshot from a TEST file where I have the Master.bat batch file that contains two separate .sas programs which runs as a whole. Once the first Job1.sas completes, it jumps to the second one and runs it course. My problem is if manually I kill the batch while Job1.sas is running, it automatically starts the Job2.sas which I don't want to. I want to stop the batch before starting the Job2.sas

atesera · ‎12-17-2024

Hi, yes that's correct. One single batch containing multiple SAS programs and once the first one finishes then second one runs and goes until the last one completed. That might be an option, but I guess I have to put a statement at the end of each program to tell the next program that it completed successfully.

atesera · ‎11-21-2024

Thanks for your response. will this code (condition abort) stop the current one or all the rest of the programs next in line. Because what I experienced with manually stopping the batch is it stops the current SAS program running but I have several SAS programs within the same batch so when current one is stopped the second one starts running. I want to stop the whole batch or terminate the system so none of the SAS programs after that even starts.

atesera · ‎11-21-2024

I start it using the Task Scheduler (start at a specific time) but i have other batches that are either manual start or by rules on Outlook.

atesera · ‎11-21-2024

Thanks @Quentin for your response. The problem is when I kill the running program within the batch that program is aborted however, the second program in the batch starts running. I want to completely stop all the programs, ones running as well as the next ones in line. I submit the batch using Task Scheduler (start at a specific time) however, when I use the Task Manager same thing happens. stops the current one but the program after it kicks in.

atesera · ‎11-21-2024

Hi, my question is 'How to completely stop a SAS batch while running?' I read through the posts available on this website however, using CTRL+BRK does only stop the current SAS program within the batch. But the next SAS program after that one still continues to run. I am looking for a procedure to bring the batch to a complete stop so that SAS terminates. So, let's say I have 3 SAS programs under the batch and when I start the batch the first programs runs and then when 1st completed then 2nd program starts and so on. When I stop the 2nd program running, yes, the 2nd one is killed however, then goes to the 3rd SAS program and that starts running. My goal is when I stop the batch, I don't want the rest of the programs run. Any ideas, suggestions are appreciated. Thanks

atesera · ‎02-16-2024

Thanks for this. However, the issue with this is that I have to use labels to display in the output csv file. I cant name the column headers in the way that I want because they are very long and doesn't allow me. So, I found the solution of labelling them in the way that I want because in the label there is no restrictions like that. So, I cant put the labels here then I get error message saying it is too long and plus I have over 200 columns in my dataset "&names." I believe that proc export step with label option would eliminate the issue and will update this topic once I hear back from the team uploading the output file into the system

Online Status	Offline
Date Last Visited	‎02-06-2025 02:04 PM

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Re: Stopping a SAS batch job completely while running

Stopping a SAS batch job completely while running

Re: Export to csv using ods causing blank row at the bottom of csv fil...