fedsql correlated subquery

acordes — Tue, 27 Dec 2022 10:43:25 GMT

I'm struggling to geting it work:

It gives the error messge:

Unsupported operation in FedSQL query: Correlated EXISTS subquery

How can I circumvent this?

I want to use fedsql as it performs much better on large caslib tables.

proc cas;
source MPG_toyota;
		create table public.sum22{options replace=true} as 
    select a.* from public.JS_MTOS_V2AA a
    where exists (select codopera from public.outys b
    where b.codopera=a.codopera);  ;
endsource;
fedSQL.execDirect / query=MPG_toyota;
quit;

Re: fedsql correlated subquery

acordes — Tue, 27 Dec 2022 11:38:40 GMT

I've found the answer.

It states.

Using FedSQL in SAS Cloud Analytic Services

...

The following SELECT statement features are not supported:
SET operations
correlated subqueries
dictionary queries
views
DS2 user-defined functions (UDFs)

https://documentation.sas.com/doc/en/vdmmlcdc/8.11/proc/p03fos5ei9l0opn1vm82gu383g10.htm

topic Re: fedsql correlated subquery in SAS Programming

fedsql correlated subquery

Re: fedsql correlated subquery