How to connect with MYSQL database using SAS Enterprise Guide with Linux platform?

1.   Firstly you have to create DSN for the database.

vim /etc/odbc.ini

[DSN]
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
Server=xxx.xxx.xxx.xx,1433
Database=xxxxxxxxx
Threading=1
UsageCount=1

save & exit

2. Now open SAS Enterprise Guide & write this statement to validate the connection.

libname=Test odbc dsn=DSN user=sa pwd=xxxxxxx connection=global schema=dbo;

If it’s run without any error then you have made a connection successfully between SQL & SAS.

Posted in SAS Theory | Leave a comment

How to install unixODBC Driver in Linux (RHEL,CentOS,Fedora)

Install the ODBC Driver 11 for SQL Server :-

1. Go & download the SQL driver
http://www.microsoft.com/en-us/download/details.aspx?id=36437
2. Extract out the native client files.
3. Open up Terminal window – change directory to the location where files where extracted

4. ./build_dm.sh

It will install unixODBC 2.3.0 because by default  SQL 11 support it
5.  ./install.sh install
6. accept the License agreement.

7. ./install.sh verify
8. odbcinst -q -d -n “ODBC Driver 11 for SQL Server”

###################### Update to  UnixODBC 2.3.2 ##################

1. Go to unixODBC (http://www.unixodbc.org/)
2. Download the unixODBC-2.3.2 version.

Link :- http://pkgs.fedoraproject.org/repo/pkgs/unixODBC/unixODBC-2.3.2.tar.gz/5e4528851eda5d3d4aed249b669bd05b/unixODBC-2.3.2.tar.gz
3. Extract the files
4. Start a Terminal session

Note: Ensure that gcc (C compiler) is installed and in PATH
Type the following commands, ensuring you are running as the root user and in the directory where the ODBC driver files where extracted.

5. ./configure –prefix=/usr –libdir=/usr/lib64 –sysconfdir=/etc –enable-gui=no –enable-drivers=no –enable-iconv –with-iconv-char-enc=UTF8 –with-iconv-ucode-enc=UTF16LE
6. make
7. make install

Posted in SAS Theory | Leave a comment

What is sas or sas system?

SAS is an integrated system of software solutions that enables you to perform the tasks such as data entry, retrieval, management, report writing and graphics design, statistical and mathematical analysis.

Posted in SAS Theory | Leave a comment

What is sas deployment tester server?

The Deployment Tester is a diagnostic tool used for assessing a SAS deployment. After an installation or upgrade, you can use the Deployment Tester to ensure that your SAS software and critical server components have been installed and configured correctly. The Deployment Tester is also useful for ongoing monitoring of the health of your deployment, as well as for troubleshooting when problems occur.

Posted in SAS Theory | Leave a comment

What is LASR & public LASR analytic server?

LASR analytic server

The SAS LASR Analytic Server is an analytic platform that provides a secure, multi-user environment for concurrent access to data that is loaded into memory.

Public LASR analytic server

This library is available for use in the SAS Folders tree, and it is located in /Shared Data/SAS Visual Analytic/Public/Visual Analytic Public LASR .

Posted in SAS Theory | Leave a comment

What is sas web infrastructure platform & data server ?

What is sas web infrastructure platform

The SAS Web Infrastructure Platform is a collection of services and applications that provide common infrastructure and integration features to be used by SAS web applications.

SAS Web Infrastructure Platform Data Server

SAS Web Infrastructure Platform Data Server is included in your deployment for use as transaction storage by SAS middle-tier software and some SAS solutions software. The server is based on PostgreSQL. The server is configured specifically to support SAS software.

Posted in SAS Theory | Leave a comment

What is workspace & pooled workspace server?

SAS Workspace Server

SAS Workspace Servers interact with SAS by creating a server process for each client connection. The workspace server process is owned by the client user who made the server request. Each workspace server process enables client programs to access SAS libraries, perform tasks by using the SAS language, and retrieve the results.

Pooled workspace  server

SAS Pooled Workspace Servers are configured to use server-side pooling and load balancing. a configuration in which the client application maintains a collection of reusable workspace server processes is called pooled workspace server.

Posted in SAS Theory | Leave a comment