I used this code to connect to an outside SQL server and it seems to have worked:
libname odbclib odbc noprompt="Driver={SQL Server};
369   Server=10.100.100.100 ;
370   Database=XXXwork;
371   Uid=;
372   Pwd=;"
373   ;
NOTE: Libref ODBCLIB was successfully assigned as follows:
      Engine:        ODBC
      Physical Name:
Can someone tell me how to get table and column names from the server now?