topic Re: proc fedsql error with path based caslib in Developers

proc fedsql error with path based caslib

Edoedoedo — Sat, 08 Sep 2018 18:44:36 GMT

Hi, we've just got Sas Viya 3.4 and I'm studying it to understand how can I improve my SAS 9.4 programs.

I have a problem with proc sql, which as I saw exists only as proc fedsql. However, here's my caslib:

caslib mycaslib path="/sas/staging/test" datasource=(srctype="path") libref=mycas;

Inside that path there exists a table named test.sashdat. I load such a table in memory:

proc casutil incaslib="mycaslib" outcaslib="mycaslib";
    load casdata="test.sashdat" casout="test" replace;
run;

Now I want, for instance, to aggregate that table to count rows by FIELD1.

proc fedsql;
    CREATE TABLE mycas.counts AS
    select FIELD, count(*) as N
    from mycas.test
    group by FIELD;
quit;

I get this error:

 ERROR: Table "MYCAS.TEST" does not exist or cannot be accessed
 ERROR: BASE driver, schema name MYCAS was not found for this connection

What is wrong?

Thanks

Re: proc fedsql error with path based caslib

Edoedoedo — Tue, 09 Oct 2018 13:58:53 GMT

Hi, does anyone have the same error or does it happen only on my config?

Thank you

Re: proc fedsql error with path based caslib

Rahul_B — Tue, 12 Feb 2019 12:10:28 GMT

Hi,

You are accessing CAS lib in fedsql but you dont have any session reference of CAS ? It is not a config issue.

cas mySession sessopts=(caslib=mycas timeout=3600 locale="en_US" metrics=true);
proc fedsql sessref=mySession;
 CREATE TABLE mycas.counts AS 
select FIELD, count(*) as N 
from mycas.test 
group by FIELD; 
quit;

I hope this should fix your problem.

Re: proc fedsql error with path based caslib

Edoedoedo — Thu, 21 Feb 2019 06:55:23 GMT

Thanks a lot, the missing sessref was the problem!