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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.