Help using Base SAS procedures

Proc DS2 with Proc Server

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

Proc DS2 with Proc Server

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.

 

 


Accepted Solutions
Solution
‎05-31-2017 04:33 PM
Super Contributor
Posts: 441

Re: Proc DS2 with Proc Server

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

View solution in original post


All Replies
Super User
Posts: 5,437

Re: Proc DS2 with Proc Server

Does this work for non-DS2 steps?
Have you tried to specify the server= option?
Data never sleeps
Solution
‎05-31-2017 04:33 PM
Super Contributor
Posts: 441

Re: Proc DS2 with Proc Server

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

Trusted Advisor
Posts: 1,301

Re: Proc DS2 with Proc Server

[ Edited ]

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

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 198 views
  • 2 likes
  • 4 in conversation