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
I've got this working now.
I've got this working now.
what went wrong?
what needed fixing?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.