What’s New in SAS 9.2
®

®

SAS Documentation


The correct bibliographic citation for this manual is as follows: SAS Institute Inc. 2008.
What’s New in SAS ® 9.2. Cary, NC: SAS Institute Inc.
What’s New in SAS® 9.2
Copyright © 2008, SAS Institute Inc., Cary, NC, USA
ISBN 978-1-59994-639-9 (electronic book)
All rights reserved. Produced in the United States of America.
For a hard-copy book: No part of this publication may be reproduced, stored in a
retrieval system, or transmitted, in any form or by any means, electronic, mechanical,
photocopying, or otherwise, without the prior written permission of the publisher, SAS
Institute Inc.
For a Web download or e-book: Your use of this publication shall be governed by the
terms established by the vendor at the time you acquire this publication.
U.S. Government Restricted Rights Notice. Use, duplication, or disclosure of this
software and related documentation by the U.S. government is subject to the Agreement
with SAS Institute and the restrictions set forth in FAR 52.227-19 Commercial Computer
Software-Restricted Rights (June 1987).
SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513.
1st electronic book, March 2008
2nd electronic book, April 2008
3rd electronic book, May 2008
1st printing, March 2008
2nd printing, April 2008

IPv6 3
Web Messaging Protocol 3
Performance
3
Security
3
Diagnostics 3
Procedures
4
Language Elements 4

Chapter 2

4 What’s New in SAS 9.2 Base Procedures

1

1

5

Overview
5
New Base SAS Procedures
6
Enhanced Base SAS Procedures
7
Documentation Enhancements
13


37
Documentation Enhancements

Chapter 6

4 What’s New in Moving and Accessing SAS 9.2 Files

Overview
39
Documentation Enhancements

Chapter 7

37

39

4 What’s New in SAS 9.2 Output Delivery System

Overview
41
New Features and Enhancements for ODS Statements

41

41

39

37

Overview
51
New Automatic Macro Variable
51
New SAS Macro System Options
51
New Options for the %MACRO Statement

Chapter 10

51

52

4 What’s New in the SAS 9.2 Scalable Performance Data Engine

Overview
53
SPD Engine Data Set Options
53
SPD Engine LIBNAME Statement Options
SPD Engine System Options
54

Chapter 11

49

53



Chapter 13

57

58

4 What’s New in the SAS 9.2 Companion for UNIX Environments

Overview
61
Direct File I/O
62
File Locking 62
SAS Remote Browser 62
Installation and Configuration Changes
Shared Executable Libraries 63

62

61


v

New Platforms for 9.2
63
SAS Language Elements 63
IPv6 Standard 65
Documentation Enhancements

74
Deprecated SAS System Options
74
Documentation Enhancements
74

Chapter 16

4 What’s New in SAS/ACCESS 9.2 Interface to PC Files

75

Overview
75
New and Enhanced Support for Import and Export Wizards and Procedures
New and Enhanced Support for PC Files Server 75
Support for New File Formats
76
Date/Time Value Differences between SAS and Microsoft Files 76
Documentation Enhancements
76

Chapter 17

4 What’s New in SAS/ACCESS 9.2 Interfaces for Relational Databases

Overview
77
All Supported SAS/ACCESS Interfaces to Relational Databases
SAS/ACCESS Interface to DB2 under UNIX and PC Hosts 78

New Features and Enhancements for Server Sign-On and Compute Services
Enhancements for Remote Library Services 81

81

77


vi

Documentation Enhancements

82

4

Chapter 19
What’s New in Communications Access Methods for SAS/CONNECT 9.2
and SAS/SHARE 9.2 83
Overview
83
Support for Security Support Provider Interface under Windows for TCP/IP
Changes to TCP/IP and XMS under z/OS
83
Changes to the Spawners 84
Documentation Enhancements
84

Chapter 20


Overview
89
AUTOREG Procedure
90
COUNTREG Procedure
90
DATASOURCE Procedure 90
New ESM Procedure
91
MODEL Procedure 91
PANEL Procedure
91
QLIM Procedure
92
SASECRSP Engine 92
SASEFAME Engine 92
SASEHAVR Engine 93
New SIMILARITY Procedure (Experimental)
UCM Procedure
94
VARMAX Procedure
95
X12 Procedure 96
References
97

Chapter 23

89



Overview
102
The SAS/GRAPH Statistical Graphics Suite
102
The SAS/GRAPH Network Visualization Workshop
Support for Multiple Open ODS Destinations
103
Support for ODS Styles
103
Device Drivers 104
Colors
104
Fonts and Font Rendering 104
Reverting to a Pre-Version 9.2 Appearance 105
Procedures
105
Global Statements
110
Graphics Options
110
Transparent Overlays
110
ActiveX Control
110
Java Map Applet
111
Java Tilechart Applet
111
The Annotate Facility 111

New Related Software
118

Chapter 26
Overview

Chapter 27

4 What’s New in SAS/IntrNet 9.2

121

121

4 What’s New in SAS/IntrNet 9.2 Application Dispatcher

Overview
123
General Enhancements

123

123

4 What’s New in SAS 9.2 National Language Support (NLS) Reference

Chapter 28
Guide
125



Chapter 30

131

131

4 What’s New in SAS/OR 9.2

133

4 What’s New in SAS/QC 9.2

139

Overview
133
The NETFLOW Procedure 133
The INTPOINT Procedure 134
The LP Procedure
134
The OPTLP Procedure
134
The OPTMILP Procedure
135
The OPTMODEL Procedure
135
The OPTQP Procedure
136
Earned Value Management Macros 136


4 What’s New in SAS/SHARE 9.2

145

Overview
145
SAS/SHARE and the SAS Intelligence Platform Environment
Changes to PROC SERVER 145
A Method to Free a Library That Contains a Locked Data Set
Relocated Information about SAS Data Security Technologies

Chapter 34

4 What’s New in SAS/STAT 9.2

Overview
148
CALIS Procedure

150

147

145
146
146

141


154
Macros
154
MCMC Procedure (Experimental) 154
MDS Procedure 154
MIXED Procedure 154
MULTTEST Procedure 154
NLIN Procedure
155
NLMIXED Procedure
155
NPAR1WAY Procedure 155
PHREG Procedure
155
PLS Procedure 155
POWER Procedure 156
PRINCOMP Procedure 156
PRINQUAL Procedure
156
PROBIT Procedure
156
PSS Application
156
QUANTREG Procedure
156
REG Procedure
157
RSREG Procedure
157
SEQDESIGN Procedure (Experimental)


160

4 New Products in SAS 9.2

SAS Scoring Accelerator for Teradata

Index

163

161
161


1

CHAPTER

1
What’s New in Base SAS 9.2:
Overview
Supported Operating Environments 1
Migration 1
ODS (Output Delivery System) and Output Formatting
Universal Printing 2
National Language Support 2
SAS Remote Browsing 2
User-Written Functions 2
IPv6 3

Universal Printing

4

Chapter 1

from any active destinations that connect with it. After the destinations close, the
package can be published to any of the publish destinations.
Measured RTF output enables you to specify how and where page breaks occur and
when to place titles and footnotes into the body of a page.
Inline formatting has new syntax and can now be nested. With inline formatting you
can change border styles individually.
Style element inheritance has been enhanced in SAS 9.2. In addition, the
functionality of the REPLACE statement has been completely incorporated into the
STYLE statement.
The TEMPLATE procedure now enables you to customize the appearance of
crosstabulation (contingency) tables that are created with the FREQ procedure.
You can now define styles by using TEMPLATE procedure syntax as well as
cascading style sheets (CSS).
You can use table header and footer style elements in the TEMPLATE procedure to
change the borders of the regions that surround the table header and footer.
The PRINT procedure now enables the insertion of blank lines and the BY variable
label on the summary line, as well as formatting of large numbers.

Universal Printing
New Universal Printers include PNG (Portable Network Graphics), SVG (Scalable
Vector Graphics) and PDFA, a printer that produces archivable PDF files that are
compliant with PDF/A-1b. All Universal Printers now render TrueType fonts for output
in all operating environments, including 31 new TrueType fonts.
Several new system options enable you to control the use, layout, viewing, security,

To support the "next generation" of Internet protocol, SAS supports the new IPv6
Internet protocol as well as the current IPv4 protocol.

Web Messaging Protocol
The SOAP (Simple Object Access Protocol) procedure enables a Web messaging
protocol that invokes a Web service through the Java Native Interface (JNI) and the
Axis2 Java Client.

Performance
SAS programs that run in batch mode and terminate before they complete can be
resumed at the DATA or PROC step that follows the last completed DATA or PROC step.
The SQL procedure has been optimized to improve the performance of queries to
external databases and SAS libraries.
The SORT procedure determines whether a data set has already been sorted before it
attempts to sort a data set.
The IBUFNO system option enables you to specify an optional number of extra
buffers to be allocated for navigating an index file.
You can specify when SAS files are written to disk by using the new FILESYNC
system option.

Security
SAS now supports the AES (Advanced Encryption Standard) data encryption
algorithm. SSL (Secure Sockets Layer) and SSH (Secure Shell) are now supported in
the z/OS operating environment.
The Secure File Transfer Protocol (SFTP) access method provides a secure connection
and file transfers between two hosts (client and server), over a network, where both
commands and data are encrypted.
The PWENCODE procedure now supports the sas003 encoding method, which uses a
256-bit key encryption method to generate encoded passwords.
You can now specify in the LIBNAME statement whether user ID and password

crosstabulation table now has an ODS template that you can customize using the
TEMPLATE procedure. Equivalence and noninferiority tests are now available for the
binomial proportion and the proportion difference. New confidence limits for the
binomial proportion include Agresti-Coull, Jeffreys, and Wilson (score) confidence limits.
The RISKDIFF option in the EXACT statement provides unconditional exact confidence
limits for the proportion (risk) difference. The EQOR option in the EXACT statement
provides Zelen’s exact test for equal odds ratios.
The UNIVARIATE procedure now produces graphs that conform to ODS styles, so
that creating consistent output is easier. Also, you now have two alternative methods
for producing graphs. With traditional graphics, you can control every detail of a graph
through familiar procedure syntax and the GOPTION and SYMBOL statements. With
ODS Graphics (experimental for the UNIVARIATE procedure in SAS 9.2), you can
obtain the highest quality output with minimal syntax and full compatibility with
graphics that are produced by the SAS/STAT and SAS/ETS procedures.
The new UNIVARIATE procedure CDFPLOT statement plots the observed
cumulative distribution function (cdf) of a variable and enables you to superimpose a
fitted theoretical distribution on the graph. The new PPPLOT statement creates a
probability-probability plot (also referred to as a P-P plot or percent plot), which
compares the empirical cumulative distribution function (ecdf) of a variable with a
specified theoretical cumulative distribution function. The beta, exponential, gamma,
lognormal, normal, and Weibull distributions are availbable in both statements.

Language Elements
Files that are located in an aggregate storage location whose filename does not
comply with SAS naming conventions can now be accessed through the %INCLUDE,
FILE, and the INFILE statements. A new DATA statement option enables notes to be
written to the SAS log at the beginning and end of each level of nested DO statements.
Several new informats and formats read and write date, time, and datetime data
that is formatted according to ISO 8601.
New character functions return information about character position or words in a

The DATASETS Procedure 8
The FREQ Procedure 8
The MEANS Procedure 9
The MIGRATE Procedure 9
The OPTIONS Procedure 9
The PRINT Procedure 9
The PWENCODE Procedure 9
The RANK Procedure 9
The REPORT Procedure 10
The SORT Procedure 10
The SQL Procedure 11
The TABULATE Procedure 12
The UNIVARIATE Procedure 12
Documentation Enhancements 13
The CV2VIEW Procedure 13
The DBCSTAB Procedure 13
The EXPORT Procedure 13
The IMPORT Procedure 13
The TRANTAB Procedure 13

Overview
The following Base SAS Procedures are new:

3 FCMP
3 JAVAINFO


6

New Base SAS Procedures

The FCMP Procedure
The FCMP procedure is new for 9.2. The SAS Function Compiler Procedure (FCMP)
enables you to create, test, and store SAS functions and subroutines before you use
them in other SAS procedures. PROC FCMP accepts slight variations of DATA step
statements, and most features of the SAS programming language can be used in
functions and subroutines that are processed by PROC FCMP.

The JAVAINFO Procedure
The JAVAINFO procedure conveys diagnostic information to the user about the Java
environment that SAS is using. The diagnostic information can be used to confirm that
the SAS Java environment has been configured correctly, and can be helpful when
reporting problems to SAS technical support. Also, PROC JAVAINFO is often used to
verify that the SAS Java environment is working correctly because PROC JAVAINFO
uses Java to report its diagnostics.

The PROTO Procedure
The PROTO procedure enables you to register, in batch mode, external functions that
are written in the C or C++ programming languages. You can use these functions in


What’s New in SAS 9.2 Base Procedures

4

The COPY Procedure

7

SAS as well as in C-language structures and types. After the C-language functions are
registered in PROC PROTO, they can be called from any SAS function or subroutine

The CONTENTS Procedure
The WHERE option of the CONTENTS procedure has been restricted. You cannot
use the WHERE option to affect the output because PROC CONTENTS does not
process any observations.

The COPY Procedure
The PROC COPY option of the COPY procedure ignores concatenations with
catalogs. Use PROC CATALOG COPY to copy concatenated catalogs.


8

The CPORT Procedure

4

Chapter 2

The CPORT Procedure
The documentation about the READ= data set option (used in the DATA statement of
PROC CPORT) was enhanced to explain when a read-only password might be required.
You can create a transport file for a read-only data set only when you also specify the
data set’s password using the READ= option in PROC CPORT. Clear-text and encoded
passwords are supported.

The CORR Procedure
The new ID statement for the CORR procedure specifies one or more additional tip
variables to identify observations in scatter plots and scatter plot matrices.

The DATASETS Procedure

The RISKDIFF option in the EXACT statement provides unconditional exact confidence
limits for the proportion (risk) difference. The EQOR option in the EXACT statement
provides Zelen’s exact test for equal odds ratios.


What’s New in SAS 9.2 Base Procedures

4

The RANK Procedure

9

The MEANS Procedure
The following enhancements have been made to the MEANS procedure:

3 The PRT statistic is now an alias for the PROBT statistic.
3 The MODE statistic can now be used with PROC MEANS.

The MIGRATE Procedure
The MIGRATE procedure now supports more cross-environment migrations. You can
migrate a SAS 8.2 data library from almost every SAS 8.2 operating environment to
any SAS 9.2 operating environment. Most SAS 6 operating environments are also
supported, but not for cross-environment migration.

The OPTIONS Procedure
The following enhancements have been made to the OPTIONS procedure:

3 Restricted options are now supported in all operating environments.
3 The value of environment variables can be displayed by using the EXPAND option.

10

The REPORT Procedure

4

Chapter 2

The REPORT Procedure
The following enhancements have been made to the REPORT procedure:

3 The PROBT statistic is now an alias for the PRT statistic.
3 The MODE statistic can now be used with PROC REPORT.
3 The STYLE/MERGE attribute name option has been added so that styles can be
concatenated. Currently, there is no way to concatenate styles using a CALL
DEFINE statement. Each time the CALL DEFINE statement is executed, it
replaces any previous style information.

3 The BY statement is now available when requesting an output data set with the
OUT= option in the PROC REPORT statement.

3 The new Table of Contents (TOC) now supports the CONTENTS= option in the
BREAK, RBREAK, and DEFINE statements.

3 The BYPAGENO=n option had been added to reset the page number between BY
groups.

3 The SPANROWS option has been added for the PROC REPORT statement. This
option permits the GROUP and ORDER variables to be contained in a box rather
than blank cells appearing underneath the GROUP or ORDER variable values.


ALTERNATE_HANDLING=
CASE_FIRST=
COLLATION=
LOCALE=
NUMERIC_COLLATION=
STRENGTH=

3 You can now specify all possible encoding values. The result is the same as a
binary collation of the character data represented in the specified encoding.
The encoding values available are found in the SAS National Language
Support (NLS): Reference Guide.


What’s New in SAS 9.2 Base Procedures

4

The SQL Procedure

11

The SQL Procedure
The following enhancements have been made to the SQL procedure:

3 A number of features have been added which enable you to optimize queries.
3 Depending on which engine type the query uses, you can replace the PUT
function with a logically equivalent expression.

3 You can replace references to the DATE, TIME, DATETIME, and TODAY

column values with TRANSCODE=NO were transcoded.

3 The SAS/ACCESS CONNECT statement has a new AUTHDOMAIN option that
supports lookup of security credentials (user ID and password) without your
having to explicitly specify the credentials.
The following new options have been added to the PROC SQL statement:
CONSTDATETIME|NOCONSTDATETIME
specifies whether the SQL procedure replaces references to the DATE, TIME,
DATETIME, and TODAY functions in a query with their equivalent constant
values before the query executes.
Note: The CONSTDATETIME option provides the same functionality as the
new SQLCONSTDATETIME system option. 4
EXITCODE
specifies whether PROC SQL sets an error code for SQL insert failures for each
statement.
IPASSTHRU|NOIPASSTHRU
specifies whether implicit pass-through is enabled.


12

The TABULATE Procedure

4

Chapter 2

REDUCEPUT
specifies the engine type that a query uses for which optimization is performed by
replacing a PUT function in a query with a logically equivalent expression.

SQLUNDOPOLICY
specifies whether the SQL procedure keeps or discards updated data if errors occur
while the data is being updated.

The TABULATE Procedure
The following enhancements have been made to the TABULATE procedure:
3 The PROBT statistic is now an alias for the PRT statistic.
3 The MODE statistic can now be used with PROC TABULATE.
3 You can specify variable name list shortcuts within the TABLE statement.

The UNIVARIATE Procedure
The UNIVARIATE procedure now produces graphs that conform to ODS styles, so
that creating consistent output is easier. Also, you now have two methods for producing


What’s New in SAS 9.2 Base Procedures

4

The TRANTAB Procedure

13

graphs. With traditional graphics, you can control every detail of a graph through
familiar procedure syntax and the GOPTION and SYMBOL statements. With ODS
Graphics (experimental for the UNIVARIATE procedure in SAS 9.2), you can obtain the
highest quality output with minimal syntax. You also now have full compatibility with
graphics that are produced by the SAS/STAT and SAS/ETS procedures.
The new UNIVARIATE procedure CDFPLOT statement plots the observed
cumulative distribution function (cdf) of a variable and enables you to superimpose a

Support (NLS): Reference Guide.


14