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?
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.