I'm getting errors when running PROC DS2 code to read a large data set residing on a different server. The LIBNAME statement uses a remote engine. SAS currently doesn't have a driver that can read remote data sets. PROC DS2 uses drivers not engines. This is not available yet in base sas as the documentation claims. SAS told me they will add a defect for their R&D. If anyone knows a work around on how to run DS2 code on a remote server please share your code. I use a remote server because the data is huge and wanted to use DS2 to minimize job run time.
proc ds2;
data test201/overwrite=yes;
method run();
set {select * from randlib.Tax_prd};
end;
enddata;
run;
These are the errors. LIBNAME randlib '/username/sasfile' server = XXXX; NOTE: Libref RANDLIB was successfully assigned as follows: Engine: REMOTE Physical Name: /username/sasfile LIBNAME randlib '/username/sasfile' server = XXXX; NOTE: Libref RANDLIB was successfully assigned as follows: Engine: REMOTE Physical Name: /username/sasfile ERROR: Compilation error. ERROR: BASE driver, schema name RANDLIB was not found for this connection ERROR: Table "RANDLIB.TAX_PRD" does not exist or cannot be accessed ERROR: Line 215: Unable to prepare SELECT statement for table