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

Configure SAS/SHARE Data Source

1. Add a line to the file named "services" (For Windows, check in c:\windows\system32\drivers\etc; for Linux and OSX, check in /etc/services) 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"
        maxTotal="8"
        maxIdle="4" 
        accessToUnderlyingConnectionAllowed="true"
    />

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

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

Related Documentation

• External Schemas and Data Sources
• Install SAS/SHARE for Integration with LabKey Server - Provides a broader overview of SAS installation and integration with LabKey Server.