topic Re: Proc DS2 with Proc Server in SAS Procedures

Proc DS2 with Proc Server

nigromx — Tue, 23 May 2017 17:06:00 GMT

Hi everyone:

I have a problem working with Proc DS2 and Proc Server together

My code for Proc Server is:

proc server id=server1 authenticate=opt;
     ALLOC LIBRARY DEMO V9 '/route/to/library';
    allocate sasfile demo.ds1;
    allocate sasfile demo.ds2;
run;

Code for client is:

libname demo server=server1;

data _NULL_;
   if 0 then set demo.ds1 nobs=n;
   call symputx('total',n);
   stop;
run;

%put &total;

proc ds2;

...

quit;

total is ok but inside ds2 the log write:

NOTE: DS2 Ignoring libname DEMO (engine REMOTE); no connection string

Any idea.

Thanks in advance.

Re: Proc DS2 with Proc Server

LinusH — Wed, 24 May 2017 06:27:06 GMT

Does this work for non-DS2 steps?
Have you tried to specify the server= option?

Re: Proc DS2 with Proc Server

ChrisBrooks — Wed, 24 May 2017 07:34:40 GMT

I may be wrong but I don't think Proc DS2 recognises SAS/SHARE libraries - locking is achieved via the LOCKTABLE option -> http://support.sas.com/documentation/cdl/en/ds2ref/69739/HTML/default/viewer.htm#n069zo2gxcg6rtn1v4x1ecpu2ncb.htm

Re: Proc DS2 with Proc Server

FriedEgg — Wed, 24 May 2017 18:16:02 GMT

SAS/SHARE is not a supported data source using the 'remote' engine. Oddly, you still should utilize it through ODBC instead.

List of supported data sources (same for FedSQL as DS2):

http://support.sas.com/documentation/cdl/en/fedsqlref/67364/HTML/default/viewer.htm#n07v02kso1fe3vn1qv7cmzyw5gbv.htm