topic Re: how to connect to metadataserver in sas command line? in Administration and Deployment

how to connect to metadataserver in sas command line?

kimmygzc — Tue, 26 Oct 2021 10:05:18 GMT

Struggling with SAS command line...

I've been using SAS EG for a while, and want to try batch work arrangement by windows CLI(for some permission level restriction I can't use scheduls in SAS EG...).

But I have to connect to metadata sever every time I start EG, which I don't know how to finish in command line, I guess there should be some sas.exe parameters to set up the "bridge" connection with [remote server address, port, user name, password...]

Is there a handbook I may follow?

appreciate in advance for any rely.

Re: how to connect to metadataserver in sas command line?

gwootton — Tue, 26 Oct 2021 12:36:46 GMT

The SAS session that Enterprise Guide connects to is a Workspace Server. The Workspace Server establishes a connection to the Metatdata Server by way of the Lev1/metadataConfig.xml file that is called by the METAPROFILE in Lev1\SASApp\sasv9.cfg. This establishes a connection to the Metadata Server using the connection details in that XML file as the process owner or in the case of SAS Token Authentication using a one-time password for the user who requested the server from the Object Spawner.

To connect to Metadata from a SAS session started in batch you could use the Batch Server to start SAS (i.e. Lev1\SASApp\BatchServer\sasbatch.cmd) which would also load that metaprofile option, or in a SAS session started from <SASHome>\SASFoundation\9.4\sas, use the metadata connection options (e.g. metaprofile, or metaserver/metaport/metauser/metapass).

Connection Options
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrmeta/n03ph3v01d4e7en1n0v7wm8o3yiu.htm

Re: how to connect to metadataserver in sas command line?

SASKiwi — Wed, 27 Oct 2021 04:16:31 GMT

SAS Management Console provides a point-and-click interface to schedule and run SAS batch programs - if you are creating EG projects then you need to export these to SAS programs first.

Is this a possibility for you? SMC needs to be installed on your PC like EG, but once it is you connect to a remote SAS server just like in EG.

Re: how to connect to metadataserver in sas command line?

Sajid01 — Sun, 21 Nov 2021 14:49:11 GMT

Hello
If one wants to run SAS code in batch mode from command line, it is not necessary to connect to the metadata server. However this is to be run a machine on which SAS is installed.