Multi-byte Character Support (DBCS)
The WPS software adds supports use of multi-byte characters. It is now possible to set the encoding to UTF-8 and to read, write and view programs, data, logs and output that include multi-byte character data. It is now also possible to use multi-byte directory and file names.
The WPS Workbench now supports use of multi-byte character. UTF-8 is the recommended encoding to use and may become the default encoding in future. WPS now supports the following multi-byte "K" DATA step functions:
WPS Workbench Remote WPS Server Connection Improvements
Improvements have been made to the way in which the WPS Workbench is used to connect to a remote WPS Server. The changes provide access to the filesystem on the remote server. This means that as well as keeping data on the remote server it is now possible to keep, develop and run SAS language programs on the remote server.
A new view provides access to both the local and remote file systems.
This feature will be of particular interest to enterprise users and for use of server, cloud, cluster or grid-based WPS installations from the WPS Workbench.
In-database Summary Off-Load
Also known as in-database processing, the WPS software can now hand-off summarisation workloads into database systems where possible. This comes in addition to hand-off of projection, selection, joining and sorting workloads already present in the WPS software.
This feature has the potential significantly to reduce the execution time of summarisation workloads running against library engines backed by a relational database or data warehouse system.
Time Series Statistics
The new WPS Time Series module adds time series analysis support to WPS with the following procedures:
- PROC ARIMA
- PROC EXPAND
- PROC FORECAST
- PROC X12
Additional Core Procedures
Support for the following procedures has been added to the WPS Core module:
- PROC HTTP
- PROC JAVAINFO
- PROC SOAP
Additional Statistics Procedures
Support for the following procedures has been added to the WPS Statistics module:
- PROC KDE
- PROC STEPDISC
- PROC VARCLUS
R language support with the new R Procedure
The R language can now be accessed via the R Procedure (PROC R).
This new procedure provides the ability to use R language within a SAS language program. R program code and datasets can be passed to and from an R environment, and log output and graphics generated by the R environment can be retrieved directly into WPS ODS output.
Connect to data and run programs remotely with WPS Communicate
WPS 3.1 sees the addition of the WPS Communicate module.
WPS Communicate adds support for connecting to remote WPS Servers, transmitting and receiving data, and remote submission of programs.
Supported syntax includes:
- PROC UPLOAD
- PROC DOWNLOAD
Connections can be made by telnet or SSH depending on platform and security requirements.
The new WPS Engine for Actian Matrix provides dedicated support for accessing the Actian Matrix (formerly known as ParAccel) database.
Call External Functions
SAS language Syntax is now supported for the following DATA step call routines and functions:
- CALL MODULE
- CALL MODULEN
- CALL MODULEC
This provides access to functions in external dll's and shared objects containing functions.
Java language object support
Support for the JAVAOBJ DATA step component and the JAVAINFO procedure has been added to WPS Core to allow the calling of methods in compiled java classes.
WHERE clause optimisation
Execution performance of WHERE clauses in WPS has significantly improved and will benefit the run time of most WHERE clauses in any DATA step or procedure. Reduction in run time could be anywhere from a factor of two to a factor of ten or more depending on the exact scenario.
Secure socket support
Support for SSL and TLS communication over sockets has been added to WPS Core.
This provides secure encrypted access to network services such as:
Emails using the email access method
Web services using the HTTP access method, PROC HTTP or PROC SOAP
Core Language Support
WPS version 3 continues the expansion of it's language support with even more new language items.