https://communities.sas.com/t5/SAS-Programming/Retrieving-Data-From-Multiple-SAS-Environment/m-p/974776#M377980 <P>If I'm understanding your requirement correctly, <A href="https://documentation.sas.com/doc/en/pgmsascdc/v_066/viyaconnref/titlepage.htm" target="_blank" rel="noopener">SAS/CONNECT</A> will provide the functionality needed to automate this reporting. If CONNECT is available on all SAS installations (it is included with Viya) then you can build a SAS application that will connect to each SAS installation and download the required reporting data automatically. You could also schedule this application so no human intervention is required.</P> Wed, 10 Sep 2025 21:45:15 GMT SASKiwi 2025-09-10T21:45:15Z https://communities.sas.com/t5/SAS-Programming/Retrieving-Data-From-Multiple-SAS-Environment/m-p/974707#M377966 <P>My client has 15 SAS environment for their 15 countries business model. So I was creating an VA report which will retrieve data using a SAS code and load to CAS to show in report this data source size is very small so instead of same set of users logging into multiple environment I'm planning to bring the data into single environment and show in the report. So the most simple way to do this is to a user can run the code in all the environment download the data and upload the data the refresh it but this is not efficient and it required lot of manual efforts. So I need support to make this requirement to work more efficient way or if this can be done or not</P> Wed, 10 Sep 2025 06:18:08 GMT https://communities.sas.com/t5/SAS-Programming/Retrieving-Data-From-Multiple-SAS-Environment/m-p/974707#M377966 Arun_P_A 2025-09-10T06:18:08Z https://communities.sas.com/t5/SAS-Programming/Retrieving-Data-From-Multiple-SAS-Environment/m-p/974776#M377980 <P>If I'm understanding your requirement correctly, <A href="https://documentation.sas.com/doc/en/pgmsascdc/v_066/viyaconnref/titlepage.htm" target="_blank" rel="noopener">SAS/CONNECT</A> will provide the functionality needed to automate this reporting. If CONNECT is available on all SAS installations (it is included with Viya) then you can build a SAS application that will connect to each SAS installation and download the required reporting data automatically. You could also schedule this application so no human intervention is required.</P> Wed, 10 Sep 2025 21:45:15 GMT https://communities.sas.com/t5/SAS-Programming/Retrieving-Data-From-Multiple-SAS-Environment/m-p/974776#M377980 SASKiwi 2025-09-10T21:45:15Z