PROC FedSQL with stochastic results

[SvenWagner]

Hi all,

I use SAS 9.4 TS Level 1M3, W32_ES08R2 Windows NT Server-Version, on a x64-based MS Windows Server 2008 R2 Enterprise operating system. When using PROC FedSQL with multiple joins and sub-queries, I sometimes get stochastic results. So far, I think to have figured out the source in the order of table processing (-> execution plan using PROC FedSQL _method; ). But: A procedure delivering results depending on the execution plan is not very useful. Has anyone made comparable experiences?

Best, Sven

[SylviaPowell]

I've passed your information along to developers and will send them this message as well. 

[SvenWagner]

Thanks!