topic Re: Batch file to run program automatically in SAS Programming

Batch file to run program automatically

Ronein — Fri, 17 Mar 2023 11:37:39 GMT

Hello

I want to create a batch file (in notepad) which is a .bat file

I want to use this batch file in order to run automatically a sas program every day.

Let's say that the sas code that I want to run is a simple and short code:

proc sql;

create table as class

select *

From sashelp.class

;

Run;

My question:

What should I write in the batch file in order to run this program on SAS?

Should I tell first to open SAS and then to run the code?

Should I put the SAS code (that I wrote before) in the batch file?

Please note that then I want to use Windows task scheduler with related to this batch file

Re: Batch file to run program automatically

LinusH — Fri, 17 Mar 2023 11:41:02 GMT

Automating SAS processes using Windows batch files - SAS Users

Re: Batch file to run program automatically

Ronein — Fri, 17 Mar 2023 11:48:22 GMT

Thank you fot the link but I still dont know what to write in the batch file for my simple task

Re: Batch file to run program automatically

Ksharp — Fri, 17 Mar 2023 11:56:40 GMT

Here is the content you should write in BAT file.

"C:\Program Files\SASHome\SASFoundation\9.4\sas.exe" -nosplash -sysin "c:\temp\temp.sas" -log "c:\temp\temp#Y#m#d-#H-#M-#s.log" -logparm "rollover=auto"

Re: Batch file to run program automatically

Kurt_Bremser — Fri, 17 Mar 2023 12:04:28 GMT

You save your code as a text file with extension .sas.

How you run this in batch depends on your SAS environment. If client/server, run it with the sasbatch script provided in the BatchServer directory of the configuration tree.

Re: Batch file to run program automatically

Ronein — Fri, 17 Mar 2023 12:06:26 GMT

Thank you.

As I see you didnt write the SAS code into the bat file.

Did you write the path where the sas program is located?

Re: Batch file to run program automatically

Ksharp — Fri, 17 Mar 2023 12:11:35 GMT

Yes. You didn't need to "write the SAS code into the bat file", just use BAT file to invoke that SAS problem .You could run it under command line or other ways as Kurt said .

Re: Batch file to run program automatically

Ronein — Fri, 17 Mar 2023 12:14:35 GMT

You mean that I need to save my SAS program ?

As I know SAS program is alway end with .SAS end.

The question is what to write in the bat file (in notepad) in order to run this program?

Then I want to create windows scheuler to run it every day auatomatically

Re: Batch file to run program automatically

Ronein — Fri, 17 Mar 2023 12:20:29 GMT

Thanks,

In the code you sent me ti write in the batch file (bat file).

Where is the directory of the sas program that I want to run ?

"C:\Program Files\SASHome\SASFoundation\9.4\sas.exe" -nosplash -sysin "c:\temp\temp.sas" -log "c:\temp\temp#Y#m#d-#H-#M-#s.log" -logparm "rollover=auto"

Re: Batch file to run program automatically

Kurt_Bremser — Fri, 17 Mar 2023 12:23:26 GMT

@Ronein wrote:

You mean that I need to save my SAS program ?

As I know SAS program is alway end with .SAS end.

No. A .sas file ends where it ends, without a special command. .SAS end would cause a syntax ERROR.

The question is what to write in the bat file (in notepad) in order to run this program?

Then I want to create windows scheuler to run it every day auatomatically

The script (or batch) file needs a line like

<path to your SAS executable or batch script> <fully qualified path to program>.sas -log <fully qualified filename of log>.log

Add more options as needed. Read the documentation for running SAS in batch mode.

Which command to use for starting SAS depends on your SAS setup, so we MUST KNOW THAT!

Re: Batch file to run program automatically

Kurt_Bremser — Fri, 17 Mar 2023 12:25:35 GMT

In the example given, the path following -sysin is the program name.

@Ronein wrote:

Thanks,

In the code you sent me ti write in the batch file (bat file).

Where is the directory of the sas program that I want to run ?
"C:\Program Files\SASHome\SASFoundation\9.4\sas.exe" -nosplash -sysin "c:\temp\temp.sas" -log "c:\temp\temp#Y#m#d-#H-#M-#s.log" -logparm "rollover=auto" 

Re: Batch file to run program automatically

Ronein — Sat, 18 Mar 2023 06:27:28 GMT

So only this part need to be modified (by the program path name )?
"c:\temp\temp.sas"

All other parts in the code are fixed?

Re: Batch file to run program automatically

Ronein — Sat, 18 Mar 2023 06:30:23 GMT

Can you please list the questions that I need to ask the admin (Or find by myself)
in order to run sas in batch mode?
As far as I understand I need:
1-path of sas program that I want to run in the batch mode
2-SAS setup
Anything else?

Re: Batch file to run program automatically

Kurt_Bremser — Sat, 18 Mar 2023 07:12:49 GMT

@Ronein wrote:
So only this part need to be modified (by the program path name )?
"c:\temp\temp.sas"

All other parts in the code are fixed?

If your SAS runs on Windows, and is installed in the default path. If your SAS server is using UNIX, the path names will be very different.

Re: Batch file to run program automatically

Ronein — Sat, 18 Mar 2023 07:14:36 GMT

"C:\Program Files\SASHome\SASFoundation\9.4\sas.exe" -nosplash -sysin "c:\temp\temp.sas" -log "c:\temp\temp#Y#m#d-#H-#M-#s.log" -logparm "rollover=auto"

what is "C:\Program Files\SASHome\SASFoundation\9.4\sas.exe" ?

Is it the path where SAS is located?

What is the meaning of -nosplash

What is the meaning of -sysin?

What is "c:\temp\temp.sas"?

Is it the path of SAS program that I want to run?

What is -log "c:\temp\temp#Y#m#d-#H-#M-#s.log" ?

IS it the location of the log file that should be created once run the sas program?

What is -logparm "rollover=auto" ?

Is it essential that the batch file (.bat) will be saved in same location of sas program file?

Re: Batch file to run program automatically

Kurt_Bremser — Sat, 18 Mar 2023 07:17:17 GMT

SAS setup needs to include

client/server or local
if c/s, type of server operating system
path names to the SAS executable or sasbatch script (with a server, sasbatch script is preferred, as it sets up the same environment you have in Enterprise Guide or SAS Studio)

Re: Batch file to run program automatically

Ronein — Sat, 18 Mar 2023 07:28:14 GMT

Any SAS program end with .sas

So I just need to save my sas program normally as I always do?

Re: Batch file to run program automatically

Ronein — Sat, 18 Mar 2023 07:34:54 GMT

You wrote "path names to the SAS executable or sasbatch script (with a server, sasbatch script is preferred, as it sets up the same environment you have in Enterprise Guide or SAS Studio)"

When you wrote "SAS executable" ,do you mean "SAS program"?

As I understand the batch script (extension .bat) is not a SAS file .

You wrote "sasbatch script "- why?

Re: Batch file to run program automatically

Kurt_Bremser — Sat, 18 Mar 2023 07:37:16 GMT

@Ronein wrote:

Any SAS program end with .sas

So I just need to save my sas program normally as I always do?

Yes. The big question is where to save it so your SAS executable can find it.

Re: Batch file to run program automatically

Kurt_Bremser — Sat, 18 Mar 2023 08:02:52 GMT

"SAS executable" is the SAS system itself, which can then be used to run your SAS program. sasbatch.sh (or sasbatch.bat) is a script file provided in a server environment, which sets up your server context (e.g. SASApp) in batch like you have it interactively. The script ulimately calls the SAS executable with parameters and environment variables correctly set.