Start a remote SAS session with the same libraries as a workspace server

ScottBass — Fri, 08 Feb 2013 03:17:01 GMT

Hi,

We have this environment:

Server:

Windows Server 2008 Enterprise x64

SAS 9.3 in a managed environment (SAS Metadata Server, Lev1/Lev2, etc).

Desktop:

Windows XP Professional x32 (bleeding edge, huh?)

SAS 9.3

Some staff still use SAS DMS on their desktop, rather than EG connecting to the workspace server on the server. I need to configure a desktop environment that instantiates a SAS/Connect session as identical as possible to an EG workspace server session, esp. with respect to the allocated libraries. The libraries are defined as pre-assigned in the metadata. Some of these libraries use the Oracle engine. The Oracle client is installed on the server.

I tried this:

%let conport = 7551;

%let sa01=our.remote.server.com &conport;

options comamid=tcp remote=sa01;

options sascmd='E:\SAS\Config\Lev1\SASApp\WorkspaceServer\WorkspaceServer.bat';

signon;

thinking that would launch the WorkspaceServer.bat file on the remote server. But, a command window flashed on my local machine, and I got an error.

On the remote server (RDP session), I did this from a command window:

D:\Program Files\SASHome\SASFoundation\9.3>sas -metaserver "remote.server.com" -metaport 8561 -metarepository "Foundation" -metaprotocol BRIDGE -metaautoresources "SASApp"

All the libraries were properly allocated. I then submitted this in SAS:

filename set pipe "set";

data _null_;

infile set;

input;

put _infile_;

run;

Partial output:

ORACLE_HOME=d:\oracle\11.2.0\client_1

Path=D:\Oracle\11.2.0\client_1\bin;D:\Oracle\11.2.0\client_1;C:\Windows\system32;C:\Windows;C:\Win

dows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Java\jre1.6.

0_24\bin;D:\Program Files (x86)\sysinternals

I submitted this on my local SAS session:

%let conport = 7551;

%let sa01=our.remote.server.com &conport;

options comamid=tcp remote=sa01;

options sascmd='sas -metaserver "remote.server.com" -metaport 8561 -metarepository "Foundation" -metaprotocol BRIDGE -metaautoresources "SASApp"';

signon;

rsubmit;

filename set pipe "set";

data _null_;

infile set;

input;

put _infile_;

run;

endrsubmit;

I won't list the results, but ORACLE_HOME wasn't set, nor was Oracle in the path. I got errors in the log for all the Oracle libraries that were pre-assigned via the metadata.

Any idea how I can instantiate a SAS/Connect session which mirrors a workspace server session instantiated by EG?

Thanks,

Scott

Re: Start a remote SAS session with the same libraries as a workspace server

ScottBass — Sun, 17 Feb 2013 22:14:38 GMT

I've got this working now.

Re: Start a remote SAS session with the same libraries as a workspace server

Peter_C — Sun, 17 Feb 2013 22:32:39 GMT

what went wrong?

what needed fixing?

topic Start a remote SAS session with the same libraries as a workspace server in SAS Programming

Start a remote SAS session with the same libraries as a workspace server

Re: Start a remote SAS session with the same libraries as a workspace server

Re: Start a remote SAS session with the same libraries as a workspace server