DataFlux Data Management Studio 2.5: User Guide

Adding SAS Data Set Connections

You can use the SAS Data Set Connection dialog to connect to a folder that contains one or more SAS data sets. The SAS data is accessed directly on disk without mediation by a server.

Perform the following steps to create a connection:

1. Click the Data riser on the DataFlux Data Management Studio desktop.
2. Select the New Data Connection menu in the Data Connections pane on the right. Then select SAS Data Set Connection to display the SAS Data Set Connection dialog.
3. Enter a name and description for the new connection into the appropriate fields.
4. Enter the path to the directory that contains one or more SAS data sets.
5. Verify that the appropriate option is specified in the Access field. DEFAULT is read-write access. READ-ONLY assigns a read-only access. TEMP specifies that the data set be treated as a scratch file.
6. Verify that the appropriate option is specified in the Compression field. If you compress data, you might experience a slowdown in performance. NO specifies that the observations are uncompressed. Use YES or CHAR to compress character data. Use BINARY to compress binary data.
7. Verify that the appropriate option is specified in the Table Locking field. SHARE specifies that other users or processes can read data from the table but prevents other users from updating. EXCLUSIVE locks tables exclusively which prevents other users from accessing any table you open.
8. Verify that the appropriate option is specified in the Encoding field. The default is the SAS System encoding. You might select an encoding that is different than the default if you are processing a file with a different encoding.
   
   You can select an encoding from the drop-down menu. If you type the first few letters of the desired encoding, the closest match will be added to this field. For more information, see the appendix, Encodings for SAS Data Sets.
9. Connection String - Displays the connection string for the SAS data set. Check the connection string to see if the appropriate options encoding has been selected for this connection. You can test the connection by clicking Test Connection.
10. Click OK to save the new connection and return to the Data riser.
11. Refresh the Data riser in order to see the new connection in the Data Connections folder in the left pane. Select View, and then select Refresh from the main menu. The new connection should appear in the Data Connections folder.
12. To verify a connection, double-click the connection in the Data Connections folder in the left pane. Enter any required credentials. If the connection works, you will be able to see tables, fields, and other attributes in the right panel.

Administrators can specify where SAS data set connections are stored. For more information, see the TKTS DSN Directory setting in the "Data Access Component Directives" topic in the DataFlux Data Management Studio Installation and Configuration Guide.