Hi all, We have 4 SAS environments in our organisation. DEV, ST, SIT and PROD. We are about to do a migration so I'd like to remove the use of explicit server names from our SAS Code. This is particularly helpful for jobs that copy data between 2 environments. There's an additional complication in that we have 2 environments on 1 physical server. Our servers are running on Windows 2008. We do have "shares" setup on the server so you can point to specific folders based on the share, but different environments have different share names. So in Prod we use RAP but Dev and ST are on the same server so they have shares named RAP_Dev and RAP_ST. My plan is to request our IT guys to create a CNAME record on the DNS server. But I would like to be very explicit in my request to avoid confusion. So a set of typical libname statements might be Dev Server libname temp_data "\\vempsas1001\RAP_Dev\temp_data"; ST Server libname temp_data "\\vempsas1001\RAP_ST\temp_data"; SIT Server libname temp_data "\\vempsas1003\RAP\temp_data"; Prod Server libname temp_data "\\pempsas1005\RAP\temp_data"; I would like to be able to use these instead. Dev Server libname temp_data "\\SASDEVSRV\temp_data"; ST Server libname temp_data "\\SASSTSRV\temp_data"; SIT Server libname temp_data "\\SASSITSRV\temp_data"; Prod Server libname temp_data "\\SASPRDSRV\temp_data"; Then I could set up a macro variable in autoexec.sas (or some config file) that would refer to the current environment by default. Eg %let env = DEV; would be in autoexec.sas Then you can use libname temp_data "\\SAS&env.SRV\temp_data"; in the code. What CNAME statements would I need to set up to be able to do this? I've googled for examples of this but have not been able to find any so any help would be greatly appreciated. Thanks, Travis
... View more