03-Dec-2021 =========================== WPS ANALYTICS RELEASE NOTES =========================== Version 4.3.4-GA-release (4.3.4.0.8714-GA-release) Information about important fixes and enhancements delivered in the latest version of WPS Analytics. 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 installed and licensed either per-user or per-machine (for all users) on all supported platforms other than IBM Mainframe. Workbench ========= - This release includes the following new Workbench features: - 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 -------- - This release includes the following new Workflow features: - The Database Explorer view: - One or more datasets can now be selected and dragged from a database connection to the Workflow canvas. - A Hub Program block. Configure a workflow ready to be deployed as an executable program for use in WPS Hub. - WPS Dataset Import block. Enables individual columns to be selected and properties modified on import. - WPS Dataset Export block. Enables a working dataset to be saved as a permanent dataset (.wpd). - Copy block. Duplicates an input dataset. - Searching for, and filtering of, variables in variable selection panels in Workflow blocks can now be carried out using fuzzy matching. - Workflow canvas: - The number of observations in a dataset can now be displayed. - Connections to and from a single block on the canvas can now be displayed. - A layout grid can now be displayed on the Workflow canvas and blocks can be automatically aligned to the canvas grid. - This release includes enhancements to the following Workflow features: - The Excel Import block and Text File Import block: - Now enable individual variables (columns) to be selected and imported. - Now enable the properties of each imported column to be specified. - Now support locale-specific date, date-time, and time formats for input variables. - Rows containing errors can be removed from the Working Dataset and output to a separate Errors dataset. - The Mutate block: - Lists all available SAS language functions that can be specified to create a variable. - Includes a preview section that enables you view the mutated variables content. - An expression statement can now be applied to multiple input variables to create multiple output variables. - An expression can now be applied across different groupings of the input dataset using the grouping variable selection. - Model report datasets can now be generated from modelling blocks. - The Decision Forest and Decision Tree blocks can now generate a confusion matrix. - The Scorecard Model block: - Can now generate scores from a dataset that contains probabilities. - Can now generate either integer or decimal scores for point allocation. - 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: - CARDSLEADINGTABSTOPS - CHARTRANINVALID - NETEZZACHARCOLUMNTYPE - ODSSTYLE - SETINITLOCATIONS - SITEINITSTMT - SITETERMSTMT - TCPMSGLEN - VARINITCHK - WPSRESIZEDSARRAY Global statements ================= - The following global statement has been added at this release: - FILENAME ZIP DATA step ========= - Resizeable direct ( _TEMPORARY_) arrays can now be created in the DATA step. ODS === - The following experimental procedures have been added at this release: - ODSLIST - ODSTEXT - The ODS PACKAGE statement is now supported. - The NEWFILE option is now supported for the ODS EXCELXP, ODS HTML, ODS MSOFFICE2K, ODS PDF, and ODS RTF destinations. General procedures ================== - The following procedure has been added at this release: - FCMP - The following general procedures have been enhanced at this release: - IMPORT. Now supports the NAMEROW and ENCODING statements. - EXPORT. Now supports the ENCODING statement. Macros ====== - The following automatic macro variables have been added at this release: - SYS_PROCHTTP_STATUS_CODE - SYS_PROCHTTP_STATUS_PHRASE - SYSODSPATH Graphing procedures =================== - The following procedures have been added at this release: - GCONTOUR - SGPIE - SGRADAR Statistical procedures ====================== - The following procedures have been added at this release: - GLIMMIX - NLMIXED - SURVEYMEANS - The following statistical procedures have been enhanced at this release: - GENMOD. Now supports the LSMEANS statement. - GLM. Now supports the MANOVA statement. - MIXED. Now supports the PARMS statement. - PHREG. Now supports the ASSESS and HAZARDRATIO statements. Operational Research procedures ====================== - The following procedure has been added at this release: - OPTQP 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 engines have been added at this release: - POSTGRESQLM - SNOWFLAKE TERADATA -------- - Now supports options to bulk insert data on the Library reference statement and through dataset options. - Now supports the CHECKPOINT, TPT_APPL_PHASE, TPT_CHECKPOINT, and TPT_RESTART dataset options. WPS Hub ======= - WPS Hub portal: - A new invocation interface has been added. - The invocation interface has the following additions: - Custom labels. - Re-run jobs. - Favourites. - WPS Hub Administration: - New configuration and installation methods: - The installation and configuration process has been simplified. - Installation packages are supplied for Microsoft Windows and Linux. - The Hub service on Windows now installs with a manual startup type. - WPS Hub now uses a YAML-formatted file for configuration. - The configuration file can now be specified using an environment variable. - Changes to licence application: - The WPS Hub licence key can now either be placed in the WPS Hub installation folders or the location specified in the WPS Hub configuration file. - Flexible LDAP support: - LDAP queries can now be configured to find users and groups in the directory. - Hub permissions controlled by access roles: - New User and Portal User roles have been added to control access permissions. - The HubUsers and HubAdministrators groups no longer control access permissions. - Users imported from LDAP are no longer automatically added to the HubUsers group. - New keys have been added to the Hub configuration file as follows: - E-mail group: - fromAddress. - listID. - smtpServer. - smtpPort. - useListID. - Bootstrap group: - adminEmail. - createDeploymentServicesEnvironments. - createOndemandExamples. - createRoleGroups. - createDemoArtifactRepositories. - Hostmonitor group: - coreThreadPoolSize. - maxThreadPoolSize. - Licence group: - key. - expiryWarning. - Ondemandclient group: - timeout. - Packagemanager group: - monitorFrequency. - transportTimeout. - shutdownTimeout. - allowInternalProgramPackages. - Portal group: - portalURL. - Userpasswords group: - hashAlgorithm. ======================================================================= 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 ----------------------------------------------------------------------- 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. IBM AIX ======= - On AIX Power 7 systems, with SMT, WPS reports CPU times as they are provided by the underlying operating system, without performing any scaling. ======================================================================= 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. - Use of Missing values in DATA step arithmetic is now consistently reported. - 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. - WPS Analytics can now be used with R version 4. - The OF iterator can now be used with direct arrays. - Graphical procedures now apply the correct defaults for the specified paper size. - The IN operator in expressions searching lists of numeric values now compares integer values only. - The IN operator can now be used to match elements in an array. - Specifying the _LAST_ system variable no longer causes WPS Analytics to fail if the referenced library is no longer valid. - WPS Analytics no longer fails if a HITER Component references a deleted HASH Component. - WPS Analytics now works as expected with the third-party ZeeDrive product. - FILENAME EMAIL now supports the INLINED option. - Lists are no longer supported in Procedure statements. - FILENAME DDEX. Date, time and datetime values formatted using the DATE_FORMAT option now work as expected. - FILENAME statements, LRECL option. The record length specified must now between 1 byte and 1e8 bytes inclusive. This applies to the CATALOG, FTP, HADOOP, HTTP, PIPE, SFTP and SOCKET filename statements. - The content of a string literal is no longer output to the log if that string literal exceeds 262 characters and the QUOTELENMAX system option is specified. - The IN operator now functions as expected when comparing a string to a list of strings that might contain characters encoded with bytes of 0x80 or above. - WPS Analytics now supports Python version 3.10 - Now supports the MASKDBCONNECTIONSTRINGS system option. - Specifying multiple LIBNAME JSON statements referencing the same JSON file now only generates a single dataset. - FILENAME DISK now supports the IGNOREDOSEOF option. Cleanwork utility ----------------- - The utility on Windows: - Now supports the force (-f), verbose (-v) and list (-n) options. - Now supports the -ff option to select a temporary directory more effectively than the -f switch does. FILENAME SFTP ------------- - Now reports when the underlying SFTP command returns a non-zero exit code. - The DEBUG option now only selects debug output for the current SFTP. - Now supports the CMD option, which enables a single command to be sent to the SFTP client. - Now supports the CMDENCODING that specifies the encoding that is to be used when communicating with the SFTP client. - Now supports the CMDFILE option, which specifies a file (fileref name or path) that contains a set of commands to send to the SFTP client. - Now supports the LSL option, which enables you to get a verbose directory listing from the server. FILENAME URL ------------ - Now handles numeric values larger than 2^31 coming from the server using 64-bit representations. FILENAME ZIP ------------ - Now supports the DEBUG option, which specifies that additional information about the zip process is written to the log. - Now supports the GZIP options, which specifies that a gzip file is created or read. MACRO ----- - 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. - WPS Analytics no longer runs indefinitely when a macro is called with an undefined named parameter. - Self-recursive text macro definitions are now correctly expanded. - In some circumstances, specifying text-expansion macro directives as global statements might cause an error during evaluation. - The %LET statement now has a maximum recursion limit of 1000000 elements. - The %SCAN() and %QSCAN() functions now support the optional modifiers argument. - Macro names for statement style macros are now limited to eight characters. - Infinite recursion checks are now improved when macros are expanded and invoked. - Comments can now be used in macro code. - Macro statements now function as expected in name and date literals. Core ==== System options -------------- - The WPSCOMPR alias can now be used for the WPSCOMPROTOCOL system option. - The YEARCUTOFF system option is now applied to two-year date values in all circumstances. - The NOXCMD option now prevents the use of a batch file and executable commands with the FILENAME SFTP statement. - The FILECONTAINERCACHESIZE option is now supported. - The SFTPCMDENCODING option is now supported. 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. - Formats applied to negative numbers now output asterisks (*) rather than 0 (zero) if the specified width is too narrow for the variable value. - Informats B8601LZ and E8601LZ now output the correct offset time value. - WEEKU, WEEKV and WEEKW formats now correctly apply format to dates at the beginning and end of the range allowable in WPS. - WEEKU, WEEKV and WEEKW formats now add trailing spaces to fill the specified width to correctly apply format output. DATA step statements -------------------- - 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. - The ARRAY statement now supports range initialisers when specifying variable-values. - DATA step components can now only be declared once in a step. - INPUT statement. When formatted input is used, now correctly uses a string informat when writing the value into a temporary array element. DATA step functions -------------------- - The CALL MODULE routine now correctly handles whitespace surrounding supplied arguments. - The HTMLDECODE function now correctly decodes the   HTML entity. - The HOLIDAY function: - Now returns the correct date when UKEASTERMONDAY is specified. - Now supports the VETRANSUSG and VETRANSUSPS arguments. - The RAND("BINOMIAL") function now allows 0 (zero) and 1 (one) as probability of success values. - The VFORMAT function now applies default format widths when a width is not specified. - The VINFORMAT function now applies default format widths when a width is not specified. - The COUNTC() function now supports the A, B, C, D, F, G, H, L, N, P, S, U, W, and X modifiers. - The URLENCODE() and URLDECODE() functions now convert to and from UTF-8 or work entirely in session encoding, depending on the value of URLENCODING system option. - The FINANCE('COUPDAYSNC') function now correctly calculates when the basis argument is 0 (zero). - Distribution-based functions now correctly calculate Poisson, Binomial, Multivariate, T, and Negative Binomial distributions that contain a very large number of events. - The KLENGTH function now returns the position of the last character that is not a literal space. - GETOPTION function. Can now be used to retrieve password options. - The LOGPDF, LOGCDF and LOGSDF logistic distribution functions now return the correct value rather than a missing value if the result is less than CONSTANT ('LOGSMALL') - Distribution functions: - Geometric distribution functions now return the accurate value for p=1. - RAND("NORMAL"). Now validates that the standard deviation is positive. - RAND("LOGNORMAL"). Now supports the log-scale and shape arguments. - RAND("NEGBINOMIAL", 0.5, 1e20). No longer causes an infinite loop - RAND("GEOMETRIC") will now return integers. Data engines ============ ODBCM ----- - Can now be used to connect to a MySQL database. - Can now be used to connect to a SybaseIQ database. - Column names are now correctly quoted in WHERE clauses generated when database engines determine that a SELECT query can partitioned and read concurrently using multiple threads in the DBSLICEPARM option. - Now supports bulk loading options when connecting to Google BigQuery. NETEZZA ------- - When bulk-loading data, CHAR, VARCHAR and LONG VARCHAR column types now use the internal encoding of Latin 9; NCHAR, NVARCHAR and LONG NVARCHAR column types now use the internal encoding of UTF-8. POSTGRESQL ---------- - When creating a column from a variable with the "w.d" format, a DECIMAL(w,0) column is created if d is 0. Otherwise, a DECIMAL(w-1,d) column is created. SNOWFLAKE --------- - The following options are now supported: - AUTHENTICATOR and AUTHENTICATOR_URL. Used to specify the authorisation method. - BL_FIELD_OPTIONALLY_ENCLOSED_BY. Used to specify the character used to enclose empty character fields during bulk load. - BL_LOAD_TRIM_SPACE. Used to trim trailing white space when the formatted column length is longer than the string. - BL_LOAD_OVERWRITE_STAGE_FILE. Used to overwrite an existing file in the staging area. - PRIVATE_KEY_PATH and PRIVATE_KEY_PASSPHRASE. Used for Key Pair Authentication. SQLSERVER --------- - Now correctly imports columns containing characters that map to UTF-8 encodings greater than 2 bytes long. SYBASEIQ -------- - The BL_DATAFILE option now works as expected. TERADATA -------- - Bulk-loading functionality using TPT now correctly loads TIMESTAMP and TIME fields. XLSX ---- - Multiple libraries now function as expected when concatenated in a new LIBNAME XLSX statement. Library engines =============== XML --- - Now correctly supports square bracket notation to select a specific element in a list. - Relative path locations are now supported in the PATH element for a COLUMN specified in an XMLMAP file. ODS === General ------- - Style options specified to the ODS MARKUP statements now determine whether white space is output with data. Leading spaces are controlled by the ASIS style option; trailing spaces by the WHITESPACE style option. - Style overrides specified in procedures and customised style elements are now output correctly. - The GTITLE and GFOOTNOTE options can now suppress the title/footnote in the output written to an ODS destination. - Named styles are now prioritised over expressed styles in output when using an escape character modifier. - The PAGESOUTPUT system option can be used to specify whether the log contains the page numbers to which procedure or data step output is written. Supported for PDF and LISTING destinations. EXCEL ----- - Now supports the CONTENTS sub-option. - Now lays out TITLE/FOOTNOTEs using all the columns in the worksheet. - Now handles ODS TEXT better and only outputs TITLEs/FOOTNOTEs that have changed. - Now outputs the values from the AUTOFILTER option in the table header row. - Specified sub-options are now preserved between invocations. - The default value for the WIDTH_FUDGE_FACTOR sub-option has been increased to 1.32. - Now generates worksheet names as expected. - The table of contents output style and content now matches other ODS destinations. - Sub-cell rich text formatting can now be applied within a cell. - Column spanning now works as expected. - Formatting gaps are now removed from headers and footers in a sheet. - The EMBED_TITLES_ONCE and EMBED_FOOTNOTES_ONCE options now work as expected. - Now converts leading tabs in variables to cell indents if the ASIS option is specified. - BY-variable substitution in now supported in the SHEET_LABEL and SHEET_NAME options when SHEET_INTERVAL=BYGROUP is specified. - User-defined format are now more accurately converted on output. - Specified styles can now be changed between invocations. - Auto-filter options are no longer applied to empty columns when multiple tables appear on the same sheet. - Non-numeric values now have the GENERAL format applied rather than TEXT. EXCELXP ------- - Now correctly processes the SHEET_INTERVAL=PAGE option. - now supports NSSPACE characters in ODS ESCAPECHAR. - The TAGATTR style attributes can now contain the colon (:) character in the value parts. LISTING ------- - Now outputs tall column cells as expected. - Rendering of boxed (TABULATE procedure) now correctly prints tables. PDF --- - Output had been updated to prevent the page number and titles from being overwritten by batch output. General procedures ================== CONTENTS -------- - The Centiles option of the PROC CONTENTS statement now works as expected. COPY ---- - Specifying OBS=0 will now correctly reset the library members. CATALOG ------- - The NEW statement now functions correctly when the target catalog already exists. - The EXCHANGE statement now functions correctly with newly-created catalogs. COMPARE ------- - Variables observed to contain both missing and non-missing differences are now only counted once in results. - The ID field name is now used rather than the label when producing summary information. - The PROC COMAPARE statement now supports the QUOTELABEL option. DATASETS -------- - Now includes compiled data step programs in the output list. DELETE ------ - An error is now generated if an unknown MEMTYPE is specified to the DATA option. EXPORT ------ - Files are now correctly exported when the variable names contain single- or double-quotation marks. - Now supports the DBLABEL option. FORMAT ------ - The PROC FORMAT statement now supports the NOPRINT option. FREQ ---- - Now correctly utilises user defined formats on output. - WPS Log output for the SCOROUT option is now suppressed when scoring statistics are not specified. HTTP ---- - Now downloads and processes files where the content length might be greater than the available memory resource. IMPORT ------ - The NAMEROW option in the PROC IMPORT statement is now supported for delimited files. - Files are now correctly imported when the variable names contain single- or double-quotation marks. - Now supports the ENDCOL, ENDROW, STARTCOL, and STARTROW statements. JSON ---- - Formats whose entries are all defined with the same data type (DATE, TIME or DATETIME) now output using picture formats when the FMTDATETIME option is specified. MEANS ----- - CLASS variables that contain leading spaces are now processed as expected. - Computing the mode statistic of a class variable containing no valid observations no longer causes the processing engine to fail. - Now truncates frequency variables to integer values during percentile calculations. - The default value for the QMARKERS option on the PROC MEANS statement is now 5 rather than 0 (zero). - Now adds the SUMWGT statistic to the output when a weight variable is specified in the VAR statement. - Gridded table format now works as expected for HTML, MSOFFICE2K and PDF destinations. OPTIONS ------- - The LONG DEFINE VALUE option now prints the correct value for the maximum number of characters in a string. PDSCOPY ------- - Accurate record counts are now written into the ISPF statistics when copying PDS and PDSE members. PRINT ----- - The LABEL statement now accepts multiple values. - Now supports the CONTENTS option. - Now outputs the correct number of decimal places for values with exact powers of 2. - The PROC PRINT statement now supports the GRAND_LABEL and NOSUMLABEL options. REPORT ------ - When the start of the value of a character variable needs to be matched with elements in a list of character variables, and one or other value contains trailing spaces, the variable matching is now treated in the same way as in other areas of WPS. - Now allows non-printing columns that occur before the last printing column to affect the style for table row. - The optional slash (/) is now correctly processed with the BREAK and RBREAK statements. 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. - The FEEDBACK option now correctly reports the original table and column names used to create a view. - When using implicit passthrough, ORDER BY clauses added to queries can now be passed to the database engine for processing. Ensure the collation orders of the database and your WPS session are compatible to avoid potential problems later in the program execution. - Specifying a non-existent variable in a CASE statement no longer causes WPS Analytics to disconnect from the database server. - Column labels containing quotation marks are now support when specifying a view using the CREATE VIEW statement. - The VALIDVARNAME system option is now correctly enforced. - When using implicit passthrough, trailing spaces are now removed from strings to enable the target database to perform comparisons between string literals and variable-length character fields. TEMPLATE -------- - The DEFINE TABLE statement now supports multibyte labels as column headers. TABULATE -------- - ODS NEWLISTING now functions correctly when outputting tables spanning multiple pages. - Now outputs the correct number of tables when the PRELOADFMT and EXCLUSIVE options are used together in the CLASS statement - Now creates header columns for each sub-table when multiple tables are written to output. - The TABLE statement now supports the NOCELLMERGE option. Graphing procedures =================== General ------- - Now accurately detects errors in the kernel density estimates when all the values in a kernel density plot are the same. Machine Learning procedures =========================== DECISIONFOREST -------------- - The Mean Square Error Statistic is now calculated accurately. DECISIONTREE ------------ - Minimum node size ratio now works as expected. OPTIMALBIN ---------- - WOEADJUST is now only used in bins where the predictor variable takes a single value. MLP --- - The Iteration History table now reports the average training residual error with the regularisation term. - Training history now correctly labels the first epoch. - No longer fails if the TRAININGSETORDERSEED sub-option of the MODEL statement is set to zero. 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. - The SYSERR variable is now correctly set if there is a syntax error when parsing the SEVERITY, GENMOD, GLIMMIX, NLIN and PHREG procedures. BIN --- - Using a BY statement now creates bins for each BY group. CANDISC ------- - CLASS variables that contain leading spaces are now processed as expected. CLUSTER ------- - The format associated with ID variable is now used when constructing a name for an observation with missing values in the OUTTREE dataset. DISCRIM ------- - CLASS variables that contain leading spaces are now processed as expected. FACTOR ------ - Now correctly takes a correlation or covariance matrix created from a CORR procedure as an input dataset. GENMOD ------ - The test for Hessian convergence using a Hessian matrix from a previous iteration rather than the one associated with the current parameter estimates. - Errors generated by functions and other Statements are now handled correctly. GLIMMIX ------- - The memory usage during computation of asymptotic covariance matrix has been reduced. - Specifying the LSMEANS statement to calculate least square mean values now generates more accurate results when WEIGHT or the FREQ variable contains missing values. GLM --- - The ADJUST option of the LSMEANS statement now works as expected when the contrast matrix has non-estimable entries. - Specifying the LSMEANS statement to calculate least square mean values now generates more accurate results when WEIGHT or the FREQ variable contains missing values. - Specifying the MANOVA statement now more accurately calculates partial correlation p-values. - Multivariate analysis results are not displayed when the hypothesis test matrix has zero degrees of freedom. 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. - The ODS output table Logistic.Type3 is now renamed to Logistic.ModelANOVA - Now ensures the final covariance matrix is positive. - The Stat.Logistic.ModelBuildingSummary table template now translates MISSING__ values to a blank in printed output. MI -- - The ACF plot output is now consistent with ACF plots from other procedures. MIXED ----- - The ADJUST option of the LSMEANS statement now works as expected when the contrast matrix has non-estimable entries. - Now produces correct LSMEANS results when a WEIGHT statement is specified. - The memory usage during computation of asymptotic covariance matrix has been reduced. - The DDFM=SATTERTHWAITE option now functions as expected. - Specifying the LSMEANS statement to calculate least square mean values now generates more accurate results when WEIGHT or the FREQ variable contains missing values. NLIN ---- - Sum statements are now correctly displayed when the LIST option of the PROC NLIN statement is specified. - CALL routines now function correctly when invoked in the procedure. NLMIXED ------- - Errors generated by functions and other Statements are now handled correctly. TREE ---- - Cluster labels are now correctly assigned in an OUT dataset when HEIGHT=R is specified. - Root nodes that have a zero frequency are now ignored when output clusters are computed for the output dataset. TTEST ----- - The TTEST statement now supports the PLOTS option. VARCLUS ------- - Now correctly takes a correlation or covariance matrix created from a CORR procedure as an input dataset. Workbench ========= - Output to ODS NEWLISTING containing Unicode characters is now correctly paged. - Character data displayed in the data grid view now uses the default format name and the width set from the length of the variable. Workflow -------- - The VALIDVARNAME system option can now be set in the preferences of the processing engine. - The Aggregate block now supports a percentage frequency function. - The Database Explorer view can now be used to connect to Teradata and Hadoop database servers. 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. - Filename SFTP is now supported. - The FILENAME file location is now correctly reported. - ODS LISTING now works as expected and no longer causes a CEEDUMP error. - The SYSJESJOBID macro variable is now set correctly when WPS is run from USS. - The sashelp.vextfl table of file references to locations now correctly shows file references defined using a DD reference or member name. - Improved the reporting of library and member locations from the CONTENTS procedure. - A FILENAME declared to a single element HLQ causing the HLQ to be considered a DD name now works as expected. - The SASDASD library can now contain compressed files with zero pages. - The SFTP client now supports the ASCII command to transcode to and from ASCII as it transfers data. ACSII transcode is specified using either the ASCII option to the FILENAME SFTP or the SFTPASCII system option. - FILENAME EMAIL now supports the OUTLIM option used to specify the OUTLIM value for the SYSOUT DD used to send email via CSSMTP. The EMAILCSSMTPOUTLIM system option must be specified. - FILEBLKSIZE(3490E) now supports sizes up to 256K. - The required variable list and input buffer dump are now output before the ERRORABEND system option causes WPS Analytics to stop. - For WPS SORT on z/OS using UTILLOC is more flexible than SORTWORK. - No longer causes an out of memory error if the format name is incorrect. - Sending Email attachments now works as expected. - DATA step, FILE statement. When a model file reference is specified with the DCB option, the block size from the model file is now used rather than the default block size for the output device. - There is now improved detection of the use of EAV disks for WPD library storage on z/OS. EAV volumes are currently not supported for library storage. 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. - WPS Hub is now supported on Debian Linux platforms. 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. - The web portal can now display the user who cancelled an asynchronous job. - An interaction log for program packages can now be viewed in the web portal. - All roles and permissions associated with a user can now be viewed in the web portal. - The web portal now only shows functionality that the logged in user has permissions to see. - Asynchronous job triggers can now be viewed by all users. - All users can now force-delete asynchronous jobs. - It is now possible to set the maximum number of concurrent asynchronous jobs for each runtime in an environment. 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. - The creation of role groups and environments on bootstrap can now be disabled in the Hub Configuration file. ======================================================================= 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. (c) 2021 World Programming