If you have data stored in a SQL Server database, you can connect using the Microsoft ODBC Driver for SQL Server. To install the client you need to:
sudo -i
curl https://packages.microsoft.com/config/linux-distribution/version/prod.repo > /etc/yum.repos.d/msprod.repo
exit
Where linux-distribution is the absolute path to the download location, and version is the version of the Linux distribution; for example a Red Hat Enterprise 7 system would write /rhel/7/.
sudo yum install mssql-tools
You are prompted to accept the size of the installation and the licence terms.
Enter YES or y where required.
[SQL Server]
Server=server-name[, port-number]
Driver=/opt/microsoft/msodbcsql-version/lib64/libmsodbcsql-version
Description=My SQL Server ODBC Driver
Where you replace server-name and, if required, port-number with your corresponding server credentials. Replace msodbcsql-version with your version of msodbcsql and libmsodbcsql-version with your version of the libmsodbcsql shared object file.
Once the client has been installed, you can test the connection using the following SAS language program:
LIBNAME DATASRC SQLSVR USER=user-name PASSWORD=password
SERVER=server-id DATABASE=dbase;
PROC DATASETS LIBRARY=DATASRC;
RUN;