Retrieving Data From Multiple SAS Environment

[Arun_P_A]

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

[SASKiwi]

If I'm understanding your requirement correctly, SAS/CONNECT 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.