Hi bnarang, I'm not using ODBC but I am using a local Windows version of SAS to connect to UNIX SAS, Oracle and SAS libraries on the UNIX box. Within the rsubmit / endrsubmit statements, I define the rfdata library and the userid and encrypted macros for the Oracle DB. These are run on the Unix box. As mentioned before, for the work library on the remote box, I'm using slibref. I define rfdata on the windows box and use the remote engine to point to it. These statement allow me to view the datasets using SAS Explorer in Windows SAS. I also do the same for the Oracle connection. I'm not familiar with ODBC, its been about 15 years since I used it, but this should point you in the right direction. Regards, Bob rsubmit rmtbox; %let userid=rfitz; %let pw=%str({SASENC}xxxxxxxxxxxxxxxxxxxxxx); libname rfdata '/net/rfdata' ; endrsubmit; libname work_r remote slibref=WORK server=rmtbox; libname rfdata remote '/net/rfdata' server =rmtbox; rsubmit rmtbox; libname sandbox oracle user="&userid" pass="&pw" path='sanddb' schema=sandbox; endrsubmit; libname sandbox remote server=rmtbox;
... View more