In data and process jobs, you can read and write to SAS Data Sets. But before you do that, you need to create a connection to these SAS Datasets. Here's how to do it in SAS Data Management Studio and Server.
In the Data Management Studio home page, go to the Data riser, right click on Data Connections > New Data Connection and then select SAS Data Set Connection.
A new SAS Data Connection dialog opens:
You can test the connection by clicking Test Connection. Then, click OK to save the new connection and return to the Data riser.
To see the new connection in the Data Connections folder, you'll need to Refresh the Data Riser.
By default, it will create a new dftk file under Data Management Studio etc\dftkdsn folder. This dftk file name will be the name of your Data Connection. You can open that file in a text editor, which will look like this:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<datafluxdocument class="dftkdsn" version="1.0">
<name>My Data Connection</name>
<description>Its Description</description>
<extprops>DFTYPE=SAS;</extprops>
<type>TKTS</type>
<domain></domain>
<attributes>
<attribute name="CATALOG">BASE</attribute>
<attribute name="DRIVER">BASE</attribute>
<attribute name="Schema">(name='SAS';primarypath='Path\To\Data\';COMPRESS=NO;LOCKTABLE=SHARE;)</attribute>
</attributes>
</datafluxdocument>
Administrators can specify where SAS data set connections are stored using the TKTS DSN directory setting.
In Data Management Server, there is no dialog to create the connection. The easiest way is to create one is in Data Management Studio, and then copy the dftk file from Data Management Studio etc\dftkdsn to the Data Management Server dftkdsn folder. If the Data Management Server is located on a different machine, you'll most likely need to edit the primarypath value. Also, you need to verify that the compression, sharing and encoding values are still correct.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.