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?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.