External SAS Data Sources: /home/

External SAS Data Sources

This topic explains how to configure a SAS data repository as an external data source.

1. Add a line to the file named "services" (check in c:\windows\system32\drivers\etc) for SAS/SHARE; for example:

sasshare    5010/tcp    #SAS/SHARE server

2. Run SAS

3. Execute a script that specifies one or more libnames and starts the SAS/SHARE server. For example:

libname airline 'C:\Program Files\SAS\SAS 9.1\reporter\demodata\airline';
     proc server authenticate=optional id=sasshare; run;

4. Add a new SAS DataSource element to your labkey.xml file, for example:

<Resource name="jdbc/sasDataSource" auth="Container"
        type="javax.sql.DataSource"
        driverClassName="com.sas.net.sharenet.ShareNetDriver"
        url="jdbc:sharenet://localhost:5010?appname=LabKey"
        maxActive="8"
        maxIdle="4" accessToUnderlyingConnectionAllowed="true"/>

5. Copy the JDBC driver jars sas.core.jar and sas.intrnet.javatools.jar to your tomcat/lib directory.

Note: We recommend using the latest version of the SAS Driver 9.2 for JDBC; this driver works against both SAS 9.1 and 9.2. At this time, the most recent 9.2 version is called 9.22-m2; the driver lists a version number of 9.2.902200.2.0.20090722190000_v920m2. Earlier versions of the 9.2 driver are not recommended because they had major problems with column data types.

6. Start LabKey Server.

7. Visit the Query Schema Browser in the folder where you wish to expose your SAS library.

8. Define a new External Schema. Choose your SAS data source, pick a library, and specify a schema name to use within this folder (this name can be different from the SAS library name).

The data sets in the library are now available as queries in this folder. You can browse them via the Schema Browser, configure them in a query web part, create custom queries using them, etc.

For more information on configuring the SAS JDBC Driver, see Introduction to the SAS Drivers 9.2 for JDBC

Note: This procedure will run SAS/SHARE in a completely open, unsecured manner. It is intended for development purposes only. Production installations should put appropriate authentication in place.

LabKey Support

LabKey Support