05-Jun-2020 =========================== WPS ANALYTICS RELEASE NOTES =========================== Version 4.3-EA2-release (4.3.0.2.3745-EA2-release) Information about important fixes and enhancements delivered in the latest version of WPS. In this document, text shown between paired angle brackets is variable, and can be replaced by required text. For example, indicates that you should specify the required path-name to a device. ======================================================================= CONTENTS ======================================================================= - What's new - Known issues - Upgrade notes - Deprecated Functionality - Closed issues - Getting support ======================================================================= WHAT'S NEW ======================================================================= General ======= - A WPS Analytics installation can now be licensed either per-user or per-machine (for all users) on all supported platforms other than IBM Mainframe. Workbench ========= - Hub program run configuration. - SAS language programs located in WPS Hub can now be configured to run in workbench using the Local Server. - Parameters can be specified for program execution. - Results can be viewed once the execution is complete. Workflow -------- - A Hub Program block has been added to enable a workflow to be published as a Hub program. - Model report datasets can now be generated from modelling blocks. - The Decision Forest and Decision Tree blocks can now generate a confusion matrix. - The Analyse Models block can now output summary statistics and a confusion matrix. - The Chart Builder can now generate pie and radar charts. System options ============== - The following system options have been added at this release: - CONNECTPAGEBREAK - CONNECTPROGRESSINTERVAL ODS === - The ODS PACKAGE statement is now supported. General procedures ================== - The following general procedures have been enhanced at this release: - IMPORT. Now supports the NAMEROW and ENCODING statements. - EXPORT. Now supports the ENCODING statement. Statistical procedures ====================== - The following procedure has been added at this release: - GLIMMIX - The following statistical procedures have been enhanced at this release: - MIXED. Now supports the PARMS statement. - PHREG. Now supports the ASSESS and HAZARDRATIO statements. Data engines ============ - In this version, the following multithreaded engines are now the standard engines, and have the standard engine name. The non-threaded engine has the original name with OLD appended; for example, MYSQLOLD. The multithreaded engines will now be used if you have the standard engine name specified. - The engine names are: Multithreaded version Legacy version MYSQL MYSQLOLD MARIADB MARIADBOLD - The following data engine has been added: - POSTGRESQLM TERADATA -------- - Now supports options to bulk insert data on the Library reference statement and through dataset options. ======================================================================= WPS Analytics known issues and getting support ======================================================================= This section contains information about known issues in this version of WPS Analytics and how to get technical support. ----------------------------------------------------------------------- Critical known issues ----------------------------------------------------------------------- None ----------------------------------------------------------------------- Major known issues ----------------------------------------------------------------------- ODBC ==== Updating or deleting rows using the ODBC engine now uses cursor-based updates via the "WHERE CURRENT OF" clause that is supported by some ODBC drivers. We currently only support this functionality for DB2 and SQL Server connections using the ODBC library engine. ======================================================================= Upgrade Notes ======================================================================= YEARCUTOFF Option ----------------- - The default value for the YEARCUTOFF system option is now 1926. The range of two-digit dates is, by default, 01-January-1926 through to 31-December-2025. As a result of this change, any WPS Analytics functionality to which a two-digit year value is specified - for example, the MDY() DATA step function - might output different results. To return to the behaviour of previous versions of WPS Analytics, specify the YEARCUTOFF system option value of 1920. ======================================================================= Deprecated Functionality ======================================================================= The following functionality is deprecated at this release and the features will be unavailable in future versions of WPS Analytics. Any SAS language programs using these features should be modified to use the recommended alternative: - ODS OLDHTML statement: - Use the ODS HTML statement. - LIBNAME ORACLEOLD statement: - Use the LIBNAME ORACLE statement. - LIBNAME DB2OLD statement: - Use the LIBNAME DB2 statement. - Support for the SQLSRV32 ODBC Driver is to be removed. You should install and use the Microsoft ODBC Driver for SQL Server in preference. ======================================================================= Closed Issues ======================================================================= General ======= - A message is now displayed in the log if data step options for input datasets are used with output datasets, or options for output datasets are used with input datasets. - YEARCUTOFF system option is now applied to two-year date values in all circumstances. - Use of Missing values in DATA step arithmetic is now consistently reported. - The _INFILE_ option to the INFILE statement can now be used when accessing a VSAM dataset. - The number of records replaced using the modify statement is now correctly reported. - WPS Analytics no longer runs indefinitely when a macro is called with an undefined named parameter. - The CleanWork utility on Windows now supports the force (-f), verbose (-v) and list (-n) options. - The %INCLUDE message now uses the file path as encountered in the source and qualifies the path with 'is file' if the resolved path is meaningfully different to the location specified in the %INCLUDE statement. - The derivatives of functions are now computed correctly in nested IF ELSE statements. - A note is now created in the log when a missing value is either the numerator or denominator in a division calculation. - The validity of one-part and two-part dataset names is now checked to ensure they conform with the value specified in the DATASTMTCHK system option. Core ==== System options -------------- - ERRORABEND and input with stop over now outputs the variable list and input buffer dump. DATA step functions -------------------- - The CALL MODULE routine now correctly handles whitespace surrounding supplied arguments. - The HTMLDECODE function now correctly decodes the   HTML entity. Formats and informats --------------------- - When using the INPUT DATA step statement, a warning is now generated if the $VARYING format is applied to a variable with an inferred numeric type. General procedures ================== CATALOG ------- - The NEW statement now functions correctly when the target catalog already exists. - The EXCHANGE statement now functions correctly with newly-created catalogs. IMPORT ------ - The NAMEROW option in the PROC IMPORT statement is now supported for delimited files. FREQ ---- - Now correctly utilises user defined formats on output. MEANS ----- - CLASS variables that contain leading spaces are now processed as expected. OPTIONS ------- - The LONG DEFINE VALUE option now prints the correct value for the maximum number of characters in a string. SQL --- - The HAVING statement now rejects invalid arguments. - The SYMGET function in the CONNECT TO statement is now supported. - The ALTER TABLE now correctly sets the sort option information. - Using the LIKE and ESCAPE options in the WHERE statement with a CREATE VIEW table now works as expected. - Using a WHERE clause to query a VIEW now functions correctly. Machine Learning procedures =========================== OPTIMALBIN ---------- - WOEADJUST is now only used in bins where the predictor variable takes a single value. Statistical procedures ====================== General ------- - Comparison adjustment calculations have been improved in the ESTIMATE statement of the LIFEREG, LOGISTIC, PHREG, and PROBIT procedures: - The two-sided adjusted p-value and confidence intervals for the ADJUST=SIMULATE method. - The adjustment results for the ADJUST=SCHEFFE method. - The adjustment results when there are non-estimable entries in contrast matrix L. CANDISC ------- - CLASS variables that contain leading spaces are now processed as expected. DISCRIM ------- - CLASS variables that contain leading spaces are now processed as expected. GENMOD ------ - The test for Hessian convergence using a Hessian matrix from a previous iteration rather than the one associated with the current parameter estimates. GLM --- - The ADJUST option of the LSMEANS statement now works as expected when the contrast matrix has non-estimable entries. LIFEREG ------- - Now displays the correct confidence limits in the output plots. LIFETEST -------- - The ProductLimitEstimate table format censored column now matches the format of the time column. LOGISTIC -------- - Now notifies a user if the input dataset contains no observations. - The equation in the linear dependency tables is now limited to 2000 characters. MIXED ----- - The ADJUST option of the LSMEANS statement now works as expected when the contrast matrix has non-estimable entries. TREE ---- - Cluster labels are now correctly assigned in an OUT dataset when HEIGHT=R is specified. TTEST ----- - The TTEST statement now supports the PLOTS option. Workbench ========= - Output to ODS NEWLISTING containing Unicode characters is now correctly paged. z/OS ==== - A new installation process is introduced with this release. - The FILE INFILE message now reports DSORG and DSNTYPE (for DSORG=PO) and ISPF stats if present. - If an error is encountered when reading input, the input buffer and variable list are now output before ABEND. - The TSOWPS CLIST now binds the output DD cards when in DMR mode. - Messages and EXIT statements in RINST REXX installer have been renumbered. - The LRECL correction factor is now properly applied for a RECFM=V dataset. - A B37 I/O abend in a DATA step is now handled as expected when closing a DATA step. WPS Hub ======= - The latest supported Hub package specification is 1.3 - A new Invocation interface has been added to enable programs to be submitted as asynchronous jobs. General ------- - Host monitoring in Hub installations now begins when the Hub starts up. - Authentication domains defined in Hub can now be specified as a case-insensitive name in SAS language programs. - Extra Hub configuration options are now supported. Available configuration options are described in the Hub User Guide. Installation ------------ - When installed, a firewall rule is now created to control access to Hub functionality on Microsoft Windows platforms. - The Hub installation process now writes configuration data to the programdata folder on Microsoft Windows operating systems. ======================================================================= Getting Support ======================================================================= How you access technical support for WPS Analytics software depends on how you purchased your software. All WPS Analytics users are able to use the user-to-user forum available at https://support.worldprogramming.com. You are welcome to use the forum to ask questions, post answers and share advice and best practices with other users. If you hold a commercial Standard Edition annual license for WPS Analytics, you are also able to use the technical support ticketing system available at: https://www.worldprogramming.com/my-account/support/tickets. Copyright (c) 2002-2020 World Programming Limited