topic Re: Run .SAS en bath mode - Linux in SAS Enterprise Guide

Run .SAS in batch mode - Linux

RaulME — Fri, 15 Mar 2024 11:28:15 GMT

Hello,

We are trying to run a SAS project (.SAS). This project internally queries a library, but every time we have tried it via batch, it says that the library is not assigned, which is completely incorrect because it is indeed assigned.

The command we are using is as follows:

sas -nodms -batch -sysin Project.sas

Internally in .sas, it queries a table:

FROM Name.name_table

The error it indicates is:

ERROR: Libref Name is not assigned.

Would it be necessary to make any call to the library or its location before running the project?

Re: Run .SAS en bath mode - Linux

Patrick — Thu, 14 Mar 2024 12:18:53 GMT

If SAS throws an error that the library is not assigned then it's just that: The library is not assigned in the SAS environment where the code runs.

Is there any environment like a SAS EG session where the exact same code does run? If so what's different? Is there a libname statement in the code or are you eventually using a pre-assigned library that doesn't get pre-assigned when running in batch (for example because you're not connecting to the SAS metadata server)?

Re: Run .SAS en bath mode - Linux

RaulME — Thu, 14 Mar 2024 12:31:17 GMT

It seems more likely that the issue is precisely the scenario you mentioned.

I'm attempting to execute a .sas file located on the same server as EG. Internally, this file creates a table in another library by selecting from a table previously registered in a library.

Re: Run .SAS en bath mode - Linux

Kurt_Bremser — Thu, 14 Mar 2024 15:48:32 GMT

In a BI Server environment, do not use SAS for batch like this. Use the sasbatch.sh shell script from the SASApp/BatchServer directory.

You still may need to add code to the program file that you have in some autoexec mechanism that EG provides (code run when a server connection is established, and code run before every submission).

Edit: replaced WorkspaceServer with BatchServer

Re: Run .SAS en bath mode - Linux

Ksharp — Fri, 15 Mar 2024 05:34:21 GMT

Maybe your LIBNAME statement is costing too much time.
Maybe you need to wait for a couple of seconds to execute the following code.
Like :

libname x odbc dsn=.... ;
data _null_;
call sleep(10,1);
run;

..........Your following code here.........

Re: Run .SAS en bath mode - Linux

DrAbhijeetSafai — Fri, 15 Mar 2024 05:53:47 GMT

I think there is a spelling error in the title of the topic. In the body of the message it is correct but in the title, there is an error.

Thank you.

- Dr. Abhijeet Safai

Re: Run .SAS en bath mode - Linux

SASKiwi — Mon, 25 Mar 2024 04:37:45 GMT

If your library is defined in SAS metadata only, then you need to Pre-Assign it for it to be executed in batch mode: