topic Re: PROC FedSQL with stochastic results in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/PROC-FedSQL-with-stochastic-results/m-p/503309#M72733 <P>Thanks!</P> Thu, 11 Oct 2018 05:38:14 GMT SvenWagner 2018-10-11T05:38:14Z PROC FedSQL with stochastic results https://communities.sas.com/t5/SAS-Procedures/PROC-FedSQL-with-stochastic-results/m-p/501773#M72687 <P>Hi all,</P><P>&nbsp;</P><P>I use SAS 9.4 TS Level 1M3,&nbsp;<SPAN>W32_ES08R2 Windows NT Server-Version,&nbsp;</SPAN>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 (-&gt; 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?</P><P>&nbsp;</P><P>Best, Sven</P> Wed, 17 Oct 2018 05:36:03 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-FedSQL-with-stochastic-results/m-p/501773#M72687 SvenWagner 2018-10-17T05:36:03Z Re: PROC FedSQL with stochastic results https://communities.sas.com/t5/SAS-Procedures/PROC-FedSQL-with-stochastic-results/m-p/503118#M72727 <P>I've passed your information along to developers and will send them this message as well.&nbsp;</P> Wed, 10 Oct 2018 15:03:31 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-FedSQL-with-stochastic-results/m-p/503118#M72727 SylviaPowell 2018-10-10T15:03:31Z Re: PROC FedSQL with stochastic results https://communities.sas.com/t5/SAS-Procedures/PROC-FedSQL-with-stochastic-results/m-p/503309#M72733 <P>Thanks!</P> Thu, 11 Oct 2018 05:38:14 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-FedSQL-with-stochastic-results/m-p/503309#M72733 SvenWagner 2018-10-11T05:38:14Z