08-Jun-2021 =========================== WPS ANALYTICS RELEASE NOTES =========================== Version 4.4-EA2-release (4.4.0.2.1605-EA2-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 ======= - The SASHELP.SLKWXL catalog can now be specified to either the CMPLIB system option or the FCMP procedure INLIB option and the following functions invoked in a program: - ACCRINT_SLK - ACCRINTM_SLK - AMORDEGRC_SLK - AMORLINC_SLK - AVEDEV_SLK - CEILING_SLK - COUPDAYBS_SLK - COUPDAYSNC_SLK - COUPNCD_SLK - COUPNUM_SLK - COUPPCD_SLK - DATDIF4_SLK - DB_SLK - DISC_SLK - DOLLARDE_SLK - DOLLARFR_SLK - DURATION_SLK - EFFECT_SLK - EVEN_SLK - FACTDOUBLE_SLK - FLOOR_SLK - MDURATION_SLK - ODD_SLK - ODDFPRICE_SLK - ODDFYIELD_SLK - ODDLPRICE_SLK - ODDLYIELD_SLK - PRICE_SLK - PRICEDISC_SLK - PRICEMAT_SLK - PRODUCT_SLK - RECEIVED_SLK - TBILLEQ_SLK - TBILLPRICE_SLK - TBILLYIELD_SLK - VARP_SLK - YIELD_SLK - YIELDDISC_SLK - YIELDMAT_SLK Workbench ========= Workflow -------- - This release includes the following new features: - The Import group now includes: - The Parameter Import block. - The Data Preparation group now includes: - The Deduplicate block. - The Text Transform block. - The Database Explorer view can now be used to connect to Teradata and Hadoop database servers. - The MLP block. A seed value for the random number generator can now be specified to initialize weights when training the model. - Workflow blocks that contain a single Input port can now be inserted between two connected blocks in an existing Workflow. - When invoking WPS Hub programs, a file or URL input stream can now be specified as a parameter value. - If the Promptable setting is specified for a Workflow parameter, the value of the parameter can be entered or modified in the Configure Parameter dialog box during Workflow execution. - This release includes enhancements to the following features: - The Chart Builder block can now draw line plots and bar charts on the same axis. System options ============== - The following system options have been added at this release: - FILECONTAINERCACHESIZE - MFILE - NOFLE - SFTPCMDENCODING Global statements ================= - The following global statement has been enhanced at this release: - FILENAME SFTP now supports the following options: - CMD - CMDENCODING - CMDFILE - LSL Formats and informats ===================== - The following informat has been added at this release: - WEEKU - WEEKV - WEEKW Output Delivery System ====================== - The ODSLIST and ODSTEXT procedures now support: - The DATA option of the procedure statement. - The FORMAT option of the ITEM and P statements. - The CELLSTYLE statement. - The TRANSLATE statement. DATA step ========= - The following functions have been added at this release: - KUPDATES - RENAME General procedures ================== - The following general procedures have been enhanced at this release: - PRINT. Now supports the GRAND_LABEL option. Graphing procedures =================== - The following graphing procedures have been enhanced at this release: - SGPANEL. Now supports the TEXT statement. - SGPLOT. Now supports the TEXT statement. Statistical procedures ====================== - The following statistical procedure has been enhanced at this release: - LOGISTIC. Now supports the UNITS statement. Time Series procedures ====================== - The following procedure has been added at this release: - VARMAX Data engines ============ The following data engine has been enhanced at this release. SNOWFLAKE -------- - Now supports Key Pair Authentication using the PRIVATE_KEY_PATH and PRIVATE_KEY_PASSPHRASE 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 ----------------------------------------------------------------------- Known issues ----------------------------------------------------------------------- None ======================================================================= Upgrade Notes ======================================================================= Changes described in this section affect the operation of the SAS language elements, and might cause your programs to stop working with errors. You should make the appropriate changes to your programs if they contain the language elements described. DATA step function - KUPDATEB ----------------------------- - If the function is invoked and all arguments are specified: KUPDATEB (string, position, n, replacement) the n argument must now be numeric. Specifying a string argument to n in this case will cause the function to fail. ======================================================================= Deprecated Functionality ======================================================================= None ======================================================================= Closed Issues ======================================================================= General ======= - Dataset variable names are now correctly converted to single-byte encodings. - The VALIDVARNAME system option is now correctly enforced in DATA step statements. - WPS Analytics now works as expected with the third-party ZeeDrive product. Core ==== System options -------------- - The NOXCMD option now prevents the use of a batch file and executable commands with the FILENAME SFTP statement. Formats and informats --------------------- - 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 functions and CALL routines ------------------------------------- - The KCOMPARE function: - Now pads the shorter of the two strings being compared. - If the compared strings are different, now returns the position of the first differing character rather than 1. - The KLEFT function now removes any leading Shift Out (SO) and Shift In (SI) characters. - The KLENGTH function now returns the position of the last character that is not a literal space. - The KUPDATE function: - Now replaces all content from the specified start position if the length argument is not supplied. - Now correctly supports length argument. - Now accurately counts the number of characters in multibyte character strings. - Now returns a Missing value if a negative value is specified to the Length argument. - The KUPDATEB function: - Now replaces all content from the specified start position if the length argument is not supplied. - Now has a 200 character default length for the returned string. - When the CALL IS8601_CONVERT routine is invoked in a procedure that allows function calls, the argument specified to contain the returned value must now be a variable rather than a constant value. Macros ------ - Macro names for statement style macros are now limited to eight characters. - Infinite recursion checks are now improved when macros are expanded and invoked. Data engines ============ 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. TERADATA -------- - Bulk-loading functionality using TPT now correctly loads TIMESTAMP and TIME fields. ODS === EXCEL ----- - 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 formats are now more accurately converted on output. - Specified styles can now be changed between invocations. PDF --- - Output had been updated to prevent the page number and titles from being overwritten by batch output. General Procedures ================== COPY ---- - Specifying OBS=0 will now correctly reset the library members. MEANS ----- - Gridded table format now works as expected for HTML, MSOFFICE2K and PDF destinations. TEMPLATE -------- - The DEFINE TABLE statement now supports multibyte labels as column headers. SQL --- - Column labels containing quotation marks are now supported when specifying a view using the CREATE VIEW statement. - The VALIDVARNAME system option is now correctly enforced. - Implicit-passthrough IN clauses now supports sort-merge joins. Machine Learning procedures =========================== OPTIMALBIN ---------- - Now outputs a predictive power table. - Now allows multibyte variable names and multibyte data in the input dataset. MLP --- - No longer fails if the TRAININGSETORDERSEED sub-option of the MODEL statement is set to zero. Statistical procedures ====================== GENMOD ------ - Programming statements that result in an error now return a missing value. - Errors generated by functions and other Statements are now handled correctly. GLIMMIX ------- - Now works as expected when fitting a null model. - The memory usage during computation of asymptotic covariance matrix of the covariance parameters has been reduced. LOGISTIC -------- - 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. - All variables in the dataset associated with the SCORE statement are now applied to each by-group model when this dataset does not contain any of the by-group variables. MIXED ----- - The memory usage during computation of asymptotic covariance matrix has been reduced. NLIN ---- - CALL routines now function correctly when invoked in the procedure. NLMIXED ------- - Programming statements that result in an error now return a missing value. - Errors generated by functions and other Statements are now handled correctly. Workbench ========= Workflow -------- - Dataset variable names can be converted to valid SAS language variable names during import. z/OS ==== - An error is now generated when reading a concatenation with an unknown PDS member. WPS Hub ======= - Triggers can now be set to run programs as another user, if the user impersonation feature is enabled. ======================================================================= 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