DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Super Contributor
Posts: 387
Accepted Solution

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

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


Accepted Solutions
Solution
‎02-17-2013 05:14 PM
Super Contributor
Posts: 387

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

Posted in reply to ScottBass

I've got this working now.

View solution in original post


All Replies
Solution
‎02-17-2013 05:14 PM
Super Contributor
Posts: 387

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

Posted in reply to ScottBass

I've got this working now.

Valued Guide
Posts: 2,177

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

Posted in reply to ScottBass

what went wrong?

what needed fixing?

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 323 views
  • 0 likes
  • 2 in conversation