WPS Version 3.1 Released

Blog

Megaphone

Posted

2014-03-31

Category

Products

Share

World Programming today released version 3.1 of their WPS software for workstations, servers and mainframes.

Version 3.1 brings a variety of new features and improvements to the WPS software.

What's New in WPS Version 3.1?

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:

  • KCOMPARE
  • KCOMPRESS
  • KCOUNT
  • KINDEX
  • KINDEXC
  • KLEFT
  • KLENGTH
  • KLOWCASE
  • KREVERSE
  • KRIGHT
  • KSCAN
  • KSTRCAT
  • KSUBSTR
  • KSUBSTRB
  • KTRANSLATE
  • KTRIM
  • KTRUNCATE
  • KUPCASE
  • KUPDATE
  • KUPDATEB
  • KVERIFY

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 summarization 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 summarization 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:

  • RSUBMIT
  • PROC UPLOAD
  • PROC DOWNLOAD

Connections can be made by telnet or SSH depending on platform and security requirements.

Actian Matrix®

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.

Additional Information

Existing Users

Existing users should visit here where you can download a readme file containing more information about all the new features and fixes in WPS 3.1.

New Users

New users should visit here where you can explore in more detail all the features available in WPS or request a free evaluation.