Since you are using ODBC you could test out the connection settings in the Windows ODBC administrator tool on your PC. Check first to see you have an SQL Server driver installed first:
With an SQL Server driver installed like above you can then create a User DSN to test a database connection. If you can get it working on your PC then you can try the same settings in SAS. If SAS is running on the Windows Server OS then you can remotely logon to it and create the same DSN connection in the ODBC Administrator tool. If SAS is running on linux then connection details need to be defined in odbc.ini and that is a job for your SAS administrator. If SAS is running on your PC then you can use the DSN you already tested.
... View more