Run a SAS Program

Introduction

Use the directive Run a SAS Program to execute SAS programs in Hadoop. These programs are written with ultra-efficient SAS DS2 language elements. The DS2 elements combine the power of SAS with threaded SQL calls. All of this execution takes place on the Hadoop cluster.

For information about programming with DS2, see the SAS 9.4 DS2 Language Reference.

Example

Follow these steps to use the Run a SAS Program transformation:

Develop and test a SAS DS2 program. The program needs to explicitly define any and all sources and targets. The directive Run a SAS Program supports SAS DS2 programs only.
In the SAS Data Loader window, click Run a SAS Program.
Copy the text of your SAS DS2 program, and then paste that program into the Code page.
Edit your SAS DS2 program as needed. When the program is ready for execution in Hadoop, click Next.
Click Start SAS program.
In the Code page, right-click and select Paste.

Note: In the pop-up menu in the Code page, the following options are invalid: Navigate out of code (backward), Navigate out of code (forward), and Syntax Help.
Verify that your entire program is now present in the text editor, edit the program as needed, and then click Next.
In the Result page, click Start SAS Program. The directive runs and generates a selectable Log icon . The final status of the directive is portrayed by an icon in the Result banner.

You can monitor the execution of your SAS program in the Run Statusdirective.
Click Save or Save As to store your directive in your local Shared Folder.