Release Information

About WPS Analytics 4.1

For a more generalised overview of the current features of WPS not just the 'new' features summarised below, please refer to the Products section.

Release Date

  • WPS version 4.1 was released on 21 Mar 2019.
  • WPS version 4.1.2 was released on 30 May 2019.
  • WPS version 4.1.3 was released on 04 Sep 2019.
  • WPS version 4.1.4 was released on 25 Nov 2019.

Related Documents

Please visit the Documentation section to view Documents For WPS Version 4.1.


New in WPS Version 4.1.3

Updates and Enhancements

WPS 4.1.3 provides fixes and minor enhancements.

New in WPS Version 4.1.2

Updates and Enhancements

WPS 4.1.2 provides fixes and minor enhancements.

New in WPS Analytics Version 4.1

This version includes many improvements, including updates to the Workbench workflows, updated procedures, and new functionality. The new and updated features in this version are described in this document.

Workflows

New and enhanced blocks and features in the Workflow Environment are provided in this version of WPS.

Workflows – new

This release includes the following new Workflow features:

  • You can now add comments to a workflow.
  • You can create local database data sources references.
  • You can now use centrally-defined database data source references (libnames) stored in WPS Hub.
  • You can now duplicate a workflow block through a right-click menu.
  • Correlation analysis has been added to Data Profiler.
  • Multiple Workflow Engines are now instantiated to enable workflows to be run in parallel.
  • The underlying SAS code that is created when a workflow is created can now be exported to a file.

This release includes new blocks:

Import blocks
  • Database Import. Enables you to import datasets from databases using a data source reference.
Data preparation blocks
  • Aggregate. Enables you to select and aggregate data, and then return values for variables in that data, such as the count, average, and sum.
  • Binning. Groups data based on selected criteria.
  • Rank. Ranks observations using one or more numeric variables.
  • Sample. Enables you to create a sample dataset from an input dataset that is representative of the input dataset. You can specify whether the sample is random or stratified.
  • Sort. Sorts a dataset based on selected criteria.
  • Transpose. Swaps rows and columns and performs associated tasks.
Code blocks
  • SQL Language. Create a dataset using SQL language SELECT statements.
Model training blocks
  • Decision Forest. Enables you to build a decision forest from an input dataset. You can then use the decision forest to analyse other datasets.
  • Hierarchical Clustering. Enables you to create a hierarchical cluster model.
  • Linear Regression. Calculates the linear regression of a variable, and returns various information such as sum of squares, R-square, coefficient of variation, parameter estimates and collinearity diagnostics.
  • MLP. Enables you to build a multilayer perceptron (MLP) from an input dataset.
Data export blocks
  • Chart Builder. Creates charts from datasets.
  • Delimited File Export. Enables you to export data to various formats, such as Excel and delimited-field text files.
  • Excel Export. Enables you to export a dataset from a workflow to an Excel Workbook.

Workflows – enhanced

This release includes the following updates to workflows:

Workflow panel
  • If you copy and paste multiple blocks, the relative positions of the blocks are now maintained.
Import blocks
  • The Text File Import block now allows you to import delimited data from file with any filename extension.
Data preparation blocks
  • The Aggregate block now uses the SUMMARY procedure to produce data.
  • The Filter block now supports simple and advanced filters.
    • A basic filter can contain either logical AND or logical OR expressions.
    • An advanced filter can contain both types of expression.
  • The Join block now allows you to visually create connections between input datasets.
  • The Mutate block now allows you to drag functions and variables into the expression editor.
Code blocks
  • The Python language, R language and SAS language blocks:
    • Now list input datasets and variables in the Configure dialog box.
    • The dataset name and variable names can be dragged to the code editor.
Model training blocks
  • Decision Tree block
    • Now enables you to export the tabular representation of the decision tree to an Excel (.xlsx) file.
    • Has an updated Preferences dialog box.
    • You can now select multiple variables and specify their treatment.
    • The Decision Tree editor is now divided into multiple pages:
      1. Tree tab: This section contains the previously release functionality, plus information on the map view.
      2. Table tab: This is a tabular representation of the decision tree created.
      3. Scoring Code. The code (scoring value) for the Decision Tree output probability value is available in either the SAS language or SQL language.
    • Peer comparison is renamed to sibling comparison.
  • The Linear Regression block now has a graphical diagnostic view.
Scoring blocks
  • The Analyse Models block now supports continuous variables.

Workbench

This release includes the following update to Workbench:

  • You can now drag a delimited text file from the File Explorer and drop it in a library.
  • You can now run the step that currently contains the cursor using either Run Step or Run Step On options on program editor context menu..
  • You can now specify in Preferences that the log is cleared each time a program or step is run.
  • Can now open encrypted databases and prompt for a key through a dialog.
  • You can now open any encrypted dataset from File Explorer, Server Explorer and Project Explorer.
  • You can now open the file location in the system file explorer from Project Explorer view, File Explorer view, and Editor tab context menu.

SAS language support

The SAS language support comprises formats, options, statements, routines, procedures and other syntax that makes up the language of SAS.

Output Delivery System

The Output Delivery System (ODS) produces output in various formats. Existing ODS features have been significantly enhanced and augmented in this version of WPS. New features are described in the following sections.

ODS updates

The ExcelXP tagset now supports the following options:

  • BLACKANDWHITE
  • CENTER_HORIZONTAL
  • EMBED_FOOTNOTES_ONCE
  • PAGES_FITHEIGHT
  • PAGES_FITWIDTH
ODS EXCEL destination

The ODS EXCEL destination has been added and enables you to output Microsoft Excel (.xlsx) files.

System options

The following system options have been added at this release:

  • CONNECTTIMEOUT
  • CONSIDERXLSXCOLWIDTHS
  • DBIDIRECTEXEC
  • DYNAMICNOBS
  • EMAILMASQUERADEHOST
  • HUB_AUTOLIBS
  • HUB_TOKEN
  • LEGACYDB2ENGINE
  • LEGACYNETEZZAENGINE
  • LEGACYODBCENGINE
  • LEGACYORACLEENGINE
  • LEGACYSQLSERVERENGINE
  • LEGACYSQLSERVRENGINE
  • LEGACYSQLSVRENGINE
  • LINKINITSTMT
  • LINKTERMSTMT
  • ODSLISTINGDEST
  • PREFERLEGACYTABLETEMPLATES
  • SCANDEFAULTMODIFIERS
  • TAGSETSTREAMVARSIZE
  • TLS_CACERTS
  • TLS_HOSTVALIDATION
  • WPDDASDLIBNAMEINFO
  • WPSCOMENCRYPTKEY
  • WPSSCATTERCOMP
  • WPSSCATTERLIMIT1
  • WPSSCATTERLIMIT2

The following system options have been updated:

  • MAPS
  • SASHELP
  • WPDDASDLIBNAMEINFO

See the section System options in the WPS Reference for Language Elements.

DATA step functions and CALL routines

This release contains new and updated DATA step functions and CALL routines.

DATA step functions and CALL routines – new

This release contains new and updated DATA step functions and CALL routines

The following functions are new:

  • SYSEXIST
  • JARO
  • JAROWINKLER
  • NGRAM
  • NLS
  • EUROCURR
  • All functions for the Tweedie distribution.

See the section DATA step functions and CALL routines in the WPS Reference for Language Elements for more information.

DATA step functions and CALL routines – enhanced

This release contains new and updated DATA step functions and CALL routines

The following functions have been updated:

  • All WALD distribution functions now support the lambda option.

See the section DATA step functions and CALL routines in the WPS Reference for Language Elements for more information.

Macros

The &=varname form of macro variable expansion is now supported.

The following macro statements can now be used in a SAS language program outside a %MACRO ... %MEND block:

  • %IF
  • %THEN
  • %ELSE
  • %DO, including %DO iterative, %DO %WHILE, and %DO %UNTIL
  • %END

General procedures

New and enhanced general procedures are provided in this version of WPS.

General procedures – new

The following general procedure has been added:

  • FONT - Provides information on the availability and location of TrueType fonts.

See the section WPS Core procedures in the WPS Reference for Language Elements.

General procedures – enhanced

The following general procedures have been enhanced:

  • OPTIONS
    • DEFINE option now supports details of where set. For example:
      Currently set by: Built-in default
  • PYTHON
    • Now supports the following options:
      • You can now specify arguments on the EXECUTE statement.
  • R
    • Now supports the following options:
      • You can now specify arguments on the EXECUTE statement.
  • REPORT
    • Now supports the following options of the DEFINE statement:
      • ID
      • PROBT (alias for PRT)
      • MODE
  • TABULATE
    • Now supports the following option of the PROC TABULATE statement:
      • EXCLNPWGT
  • TRANSPOSE
    • Leading and trailing spaces in variable names are removed, even if the VALIDVARNAME=ANY system option is set.
  • UNIVARIATE
    • Now supports the following options of the HISTOGRAM statement:
      • MAXNBIN
      • NROWS
      • NCOLS

See the section WPS Core procedures in the WPS Reference for Language Elements.

Analytics

New and enhanced statistics and time series procedures are provided in this version of WPS.

Statistical procedures – new

The following statistical procedures have been added:

  • ASSOCRULES - Performs associative rule mining or matching on WPS datasets.
  • GAM - Enables the fitting of generalised additive models.
  • PLAN - Determine groups for trials.
  • QUANTREG - Enables the fitting of quantile regression models.
  • ROBUSTREG - Enables the use of robust regression.
  • RSREG - Enables the use of response surface regression.
  • TPSPLINE - Fits thin-plate splines to continuous data.

See the section WPS Statistics in the WPS Reference for Language Elements.

Statistical procedures – enhanced

The following procedures have been enhanced at this release:

  • NPAR1WAY - Now supports the EXACT statement.
  • SURVEYSELECT - Now uses the Mersenne twister algorithm by default to generate samples. The STRATUMSEED option and values, and RANUNI option can be used to specify which algorithm to use to generate samples.
    • The PROC SURVEYSELECT statement now supports the following options:
      • GROUPS
      • METHOD. The following methods are now supported:
        • BALBOOT
        • BERNOULLI
        • POISSON
        • PPS
        • PPS_BREWER
        • PPS_MURTHY
        • PPS_SAMPFORD
        • PPS_SEQ
        • PPS_SYS
        • PPS_WR
        • SEQ_POISSON
        • SRS
        • SYS
      • RANUNI, which can be used to reproduce results generated using WPS version 4.0.
      • REP. The following value has been added:
        • REPNAME = name
      • ROUND
      • STRATUMSEED
    • The FREQ statement has been added.
    • The STRATA statement now has support for the following options:
      • ALLOC
      • ALLOCMIN
      • ALPHA
      • COST
      • MARGIN
      • NOSAMPLE
      • STATS

See the section WPS Statistics in the WPS Reference for Language Elements.

Time series procedures – new

The following time series procedure has been added:

  • AUTOREG - Fits autoregressive time series models.

See the section WPS Timeseries in the WPS Reference for Language Elements.

Graphing procedures

The following graphical procedures have been added:

  • GINSIDE - Tests a point to determine whether it is inside a specified region of the map.
  • GPROJECT - Transforms map coordinates to a two-dimensional projected space.
  • SGPANEL - Outputs multiple plots where each plot is determined by the class of data in the input dataset.
  • SGPLOT - Draws one or more plots on a single set of axes.

See the section WPS Graphing in the WPS Reference for Language Elements.

Machine learning procedures

The following machine learning procedures have been added:

  • DECISIONFOREST - Enables you to build a decision forest from an input dataset. You can then use the decision forest to analyse other datasets.
  • SEGMENT - Determines the optimal way to segment a dataset.

See the section WPS Machine Learning in the WPS Reference for Language Elements.

Operational research procedure

The following operational research procedure has been added:

  • LP - Solves a linear programming problem.

See the section WPS Operational Research in the WPS Reference for Language Elements.

Quality Control procedures

The following WPS Quality Control procedure has been added:

  • CAPABILITY - A procedure designed to establish whether a product is producing a satisfactory solution through establishing whether it falls between set specifications.

See the section WPS Quality Control in the WPS Reference for Language Elements.

WPS Communicate

Enhancements to WPS Communicate.

  • You can now nest RSUBMIT and ENDRSUBMIT statements.

Upgrading to WPS Analytics version 4

SAS program files used with WPS version 3 are compatible with WPS Analytics version 4.

TEMPLATE Procedure: any templates generated with a previous version of WPS and saved in an itemstore must be regenerated with WPS version 4.

Please refer to the release notes available on the documentation page for information about using the Netezza, ODBC, Oracle and SQL Server data engines with WPS Analytics Version 4.

A new WPS Analytics licence key is required to activate version 4 features.

To find out more about upgrading to version 4, please contact our sales team.