BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
nigromx
Fluorite | Level 6

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisBrooks
Ammonite | Level 13

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

3 REPLIES 3
LinusH
Tourmaline | Level 20
Does this work for non-DS2 steps?
Have you tried to specify the server= option?
Data never sleeps
ChrisBrooks
Ammonite | Level 13

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 Employee

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

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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