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
Please post your question as a self-contained data step in the form of "have" (source) and "want" (desired results).
I won't contribute to your post if I can't cut-and-paste your syntactically correct code into SAS.
