06-30-2011 01:22 PM
I need to conditionally connect to different SQL Server in SAS programs based on the server the SAS porgram runs. How to get the server identifying information?
Thanks a lot in advance!
06-30-2011 11:37 PM
Automatic macro variables are the key. SYSHOSTNAME holds the name of the server running SAS, and SYSSCP and SYSSCPL reveal the operating system under which SAS it executing. Try something like this:
PUTLOG "NOTE: This is execuing on server &SYSHOSTNAME";
PUTLOG "NOTE: SAS is running under &SYSSCPL &SYSSCPL";