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;
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
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
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.