BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
acordes
Rhodochrosite | Level 12

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;
1 ACCEPTED SOLUTION

Accepted Solutions
acordes
Rhodochrosite | Level 12

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 

View solution in original post

1 REPLY 1
acordes
Rhodochrosite | Level 12

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 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 567 views
  • 0 likes
  • 1 in conversation