Monthly Archives: September 2015

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 … Continue reading

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. … Continue reading

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. … Continue reading

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 … Continue reading

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 … Continue reading

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 … Continue reading

Posted in SAS Theory | Leave a comment