DataFlux Data Management Studio 2.7: User Guide

SAS Code Node

Use a SAS Code node to write and store SAS code that will be executed on a SAS Workspace Server. You can insert this node into the flow of a process job at a point where SAS processing is needed. For more information about the tabs at upper left of this dialog, click the following links:

• SAS Code Tab - A SAS code editor.
• SAS Log Tab - Displays a SAS log.
• SAS Output Tab - Displays SAS output.
• Settings Tab - Use the SAS Workspace Server section to connect to the server that will execute the SAS code. The SAS Code node requires a SAS Workspace Server, version 9.0 to 9.4. You must supply the name and password for a user who is registered on the SAS Metadata Server. See "Specifying Passwords" below.
• Inputs Tab
• Outputs Tab
• Node Connections Tab
• Log tab

You can set the advanced properties for the SAS Code node on the Inputs tab. The advanced properties used by this node include:

• SAS_CODE_STRING
• SAS_DOMAIN
• SAS_HOST
• SAS_LIST_STATUS
• SAS_LIST_WORKTABLE
• SAS_LOG_STATUS
• SAS_LOG_WORKTABLE
• SAS_MACROS
• SAS_PASSWORD
• SAS_PORT
• SAS_STEPEVENTS
• SAS_USER

Specifying Passwords

There are several ways to supply a password for the SAS Workspace Server that is specified on the Settings tab for the SAS Code node.

If you enter a password in the password field on the Settings tab, then the password will be encoded and stored in the node variable SAS_PASSWORD.

If you want to set the value of SAS_PASSWORD dynamically, you can use a source binding to specify the job node that will update the value of SAS_PASSWORD. Note that you will have to encode the password yourself. For example, you can bind the SAS_PASSWORD input variable to a process job variable or to a node output variable of another node in the same stream.

The general steps are as follows: 

1. Encode the password.
   
   For DataFlux Data Management Studio 2.4, encode the password using the proprietary DataFlux utility EncryptPassword.exe. This utility can be found in the bin directory for DataFlux Data Management Server 2.4. For DataFlux Data Management Studio 2.5, access a SAS session and use the SAS procedure pwencode to generate the encoded password.
2. Store the encoded password somewhere, perhaps in a flat file, a database table, or a macro variable in macro file.
3. If you stored the encoded password in a macro variable, then you can directly reference it in the properties window of the SAS Code node by going to the Inputs tab, selecting SAS_PASSWORD, and in the initial value type %%name_of_my_user_defined_macrovar%%.
   
   If you stored the encoded password it in a file or database, then you could use an Expression node to read the encoded password and store it in a node output variable of the Expression node. In the SAS Code node, you would then bind SAS_PASSWORD to the specific node output variable of the Expression node.

Do not enter a macro in the Password field on the Settings tab. Because the value in the field is encrypted, it is not recognized as a macro and it is never resolved. Instead, use the following process.

First, edit the job manually in a text editor and embed the macro in the appropriate place, as shown in the following example:

<val name="SAS_PASSWORD" nullmacro="0" type="STRING">

<row>

<col>%%COM_SASCODEPASSWORD%%</col>

</row>

</val>

Then, encrypt the password. Use the dmsadmin crypt command in UNIX, EncryptPassword.exe in Windows, or PROC PWENCODE in SAS.

Finally, enter the encrypted value in the macro.cfg file.