SAS Studio: Help Center

Does SAS Studio support database connections?

Yes! If SAS/ACCESS is installed on your SAS server, you can access database files by using a LIBNAME statement and specifying the connection options for your database.

For example, you could use a LIBNAME statement to connect to an ORACLE database as follows:

libname mydblib oracle user=testuser password=testpass path=pathname;

If SAS/ACCESS is not installed on your server, then you might be able to access your database data by first exporting the data from the database as a delimited file. You can then import the data in SAS Studio by using the Import tool. For more information, see "Importing Data" in SAS Studio: User's Guide.