I have two servers - SasApp1 & SASApp2, and they sit on Linux. I can select the server I want to connect to with SAS EG and run the SAS code. Can I do it with SAS code instead of choosing a server through the SAS EG options? Here is the pseudocode of what I'm after: %IF &SomeMacroToIdentifyServer = SASApp1 %THEN %DO;
.....Deselect/Disconnect from SASApp1.....
.....Select/Connect to SASApp2.....
.....Run data/Proc steps.....
.....Deselect/Disconnect from SASApp2.....
.....Select/Reconnect to SASApp1.....
%END;
%ELSE DO;
.....Run data/Proc steps.....
%END; This is because SASApp2 has the correct configurations for PROC HTTP calls to SharePoint, and SASApp1 won't allow the connection for reasons I don't know. However, most people use SASApp1 for all of their SAS processes. If there were a programmatic way to switch between the two, we wouldn't have to worry about halting our processes that run in SASApp1 to change to SASApp2 manually and then running the rest of the process involving PROC HTTP.
... View more