Procedures that are
enabled for processing inside the database generate more sophisticated
queries that enable the aggregations and analytics to be run inside
the database. The following Base SAS procedures have been enhanced
for in-database processing inside the Aster
nCluster,
DB2 under UNIX and PC Hosts, Greenplum, Netezza, and Teradata databases:
The CIMPORT procedure
supports case-sensitive names from the CPORT file and SAS name literals
with embedded blanks. When used in batch mode, data set names and
member names that are used with the CPORT procedure can be up to 32
bytes in length.
In the CORR procedure,
you can specify one or more tip variables to identify observations
in scatter plots and scatter plot matrices.
The CPORT procedure
supports case-sensitive names for file and catalogs in a
SAS/ACCESS
engine library and SAS name literals with embedded blanks. When used
in batch mode, data set names and member names that are used with
the CPORT procedure can be up to 32 bytes in length.
The FCMP procedure has
new functions to compute the quantile and limited moment of any distributions
for which a cumulative distribution function has been defined.
The FORMAT procedure
supports creating a format catalog that corresponds to the current
SAS locale, has several new directives, and can create a format that
performs a function on a value. You can use SAS Explorer to view format
and informat definitions.
The FREQ procedure now
produces several types of plots by using ODS Graphics. New tests and
limits are available for the binomial proportion, the proportional
difference, and equal odds ratios.
The new GROOVY procedure
can run GROOVY statements in your SAS code.
The OPTIONS procedure
has new options that list system options whose value can be modified
by the INSERT and APPEND system options, and list system options that
can be restricted by your site administrator. You can now list information
about one or more options. Valid values for an option now display
in procedure output as well as the name of the configuration file
that set an option.
The OPTLOAD, OPTSAVE,
and OPTIONS procedures are also documented with system options in
SAS System Options: Reference.
The PRINT procedure
is fully integrated with the Output Delivery System. Each BY group
is a separate table. Bylines can be up to 512 characters. In all destinations
but the LISTING destination, the size of the column label does not
have to be restricted.
If you use the PRINTTO
procedure to write to a file or to a catalog entry, you must open
the LISTING destination. In objectserver run mode, log messages are
not routed to the log that is specified by the ALTLOG= system option.
The PWENCODE procedure
uses the _PWENCODE macro variable, which can be set by the OUT= fileref.
The new QDEVICE procedure
creates reports about SAS devices and universal printers.
The REGISTRY procedure
can follow links that are found when processing the LIST command and
can display only keys.
The REPORT procedure
supports multilabel formats for all ODS destinations, data sets, and
the REPORT window.
The SCAPROC procedure
can expand macro invocations into separate tasks and enhancements
for grid-enabled jobs.
The SORT procedure can
eliminate observations from an output data set and write these observations
to another data set if the observations have a unique sort key or
if the observations are adjacently unique.
New options for the
PROC SQL statement help control the execution and the resulting output.
The LIBNAME statement can be reused by the CONNECT statement when
a connection has already been established. New macro variable specifications
are available for the INTO clause of the SELECT statement. The new
VIEW_SOURCES dictionary table contains a list of tables that are referenced
by SQL. The SQL procedure documentation and the system options that
pertain to SQL have been moved to the
SAS SQL Procedure User's Guide,
placing all SQL information in one document.
The TABULATE procedure
has an option to not merge data cells with other data cells in a table.
The UNIVARIATE procedure
now produces graphs that conform to ODS styles and can create graphs
by using ODS Graphics. New statements plot the observed cumulative
distribution function of a variable and create a probability-probability
plot.