What’s New in SAS 9.3 In-Database Products: User’s Guide

Overview

Starting in SAS 9.3, the user documentation for format publishing, in-database procedures, and the Scoring Accelerator have been combined into this document, SAS 9.3 In-Database Products: User’s Guide.

Support for Teradata V13, Netezza V6.0, and Aster nCluster V6 has been added.

Some Base SAS procedures have been enhanced for in-database processing inside Netezza.

Consolidation of In-Database User Documentation

Starting in SAS 9.3, the user documentation for these in-database technologies has been combined into this document, SAS 9.3 In-Database Products: User’s Guide:

Format publishing and the SAS_PUT() function were previously documented in SAS/ACCESS for Relational Databases: Reference.
In-database procedures was previously documented in SAS/ACCESS for Relational Databases: Reference.

Note: Each in-database procedure has its own specific considerations and limitations. For more information, see the documentation for the procedure.
Scoring Accelerator was previously documented in the SAS Scoring Accelerator: User’s Guide for each database.

The in-database installation and configuration documentation can be found in SAS In-Database Products: Administrator's Guide.

Compiled Publishing Macros

In SAS 9.3, all publishing macros are compiled for better security. There is no change in the way you run the publishing macros.

Additional Alias for INDCONN Macro Password Argument

You can now use PASS= for the password argument in the INDCONN macro variable.

In-Database Procedures

There are several enhancements to in-database procedures:

You can use the SAS In-Database technology to run some Base SAS procedures inside Netezza.
In BY-group processing, the NOTSORTED option is now ignored because the data is always returned in sorted order. Previously, the NOTSORTED option was not supported.

DB2 Changes

Format publishing is now supported. Format publishing enables you to execute SAS PUT function calls inside the database. You can reference most of the formats that SAS supplies and the custom formats that you create with PROC FORMAT.

Netezza Changes

The following changes have been made for Netezza:

Support for Netezza V6.0 has been added.
Support for Netezza Performance Server (NPS) has been dropped.
You can now run Netezza format and model publishing macros in fenced mode and in unfenced mode. Fenced mode means that the format and scoring functions that are published are isolated in a separate process in the Netezza database when they are invoked, and an error does not cause the database to stop. When the format or scoring functions are ready for production, you can run the macro to publish the functions in unfenced mode.

Aster nCluster Changes

The following changes have been made for Aster nCluster:

Support for Aster nCluster V6 has been added.
If you use Aster nCluster V6, you can specify a schema where the scoring model files are published. You specify this schema in the INDCONN macro variable, and you can use the MODEL_SCHEMA parameter in the SAS_SCORE() function when you execute the scoring model.