Proc DS2 with Proc Server

[nigromx]

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.

[LinusH]

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

[ChrisBrooks · Accepted solution]

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#n069zo2gxcg6rtn1v4x...

[FriedEgg]

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#n07v02kso1fe3vn1...