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


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.

This entry was posted in SAS Theory. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s