UNCLE PROFESSIONAL 2010 and UNCLE STANDARD 2010 release w05's new features include the following:
New Graphical User Interface: Employing Microsoft’s new Ribbon User Interface. This replaces and consolidates the functionality of the traditional Menus and Toolbar, resulting in features that are more accessible with fewer mouse clicks.
&CO Title Control Word: Centers the title text up to the next positioning control word or the end of the title.
JUSTIFY Request: Used to left- or right-justify the data – numeric or text - in one or more specified data fields. Available options include: Zero-filling of numeric fields; removal of non-numeric characters from numeric fields, such as dollar signs ($) and commas (,), retaining lead negative signs (-) and decimals (.); adjustment of numeric values to a consistent number of decimals, either by adding zeros or truncating and rounding; optional zero-filling of blank fields
Numeric Data Fields: Imported data may now have commas imbedded in values as well as decimals, and will be properly evaluated with the R-, F-, A-, PC-, SD-, SE-, M-, and V-qualifications. For instance, the coded values 01000. 1000.0 001000 1,000. and 01,000 will all be evaluated as 1000 by UNCLE.
ADDRECORD Request: Creates a new, empty data record for each case that can later be used to receive data via MERGE, CALCULATE, and so on. Records may optionally be added using the Add Record dialog.
EXTENDRECORD Request: Similar to the ADDRECORD request, except this request is used to simply extend the length of an existing record, providing additional data positions. This request may be used with hierarchical databases as well. Records may optionally be added using the Extend Record dialog.
DUPLICATE Request: Enhanced to show both Case ID number and sequential record number for each displayed error.
GETSPSS Request: This request has been enhanced in a number of ways: The sequential ID number assigned to the first data field in each new record may now be of a user-defined length rather than of a length dictated by the number of incoming cases; new prompts have been added to enter the E-files table specifications into the project’s table library T-file, and to load the C-file’s ASCII data into the project’s database D-file; a simple banner table is created, resulting in ready-to-run tables at the completion of the GETSPSS request’s execution; the 8 character variable name limitation has been enhanced to accept up to the 16 character limit; files created from an SPSS file stored in a folder with a period “.” in its name are now properly named and stored.
SET CHARACTER ON/OFF: Will alter the default external data file format from PC Column Binary to ASCII/CHARACTER, impacting the default data format of the LOAD, MERGE, and PUNCH requests and their corresponding dialogs.
BINARY Keyword: Added to the LOAD, MERGE, and PUNCH requests to alter the default data format to PC Column Binary when the SET CHARACTER ON request has been used to change the default to ASCII/CHARACTER data.
The Caret “^” Symbol: May now be appended to any UNCLE request issued at the Uncle prompt, with any labeling text following accepted as a comment. This is useful for labeling DISTRIBUTION and similar requests.
AUTOTAG Table Option: This will insert each column’s TAG option symbol (the first or only) as part of each column’s text. Options include: the characters to enclose each TAG symbol, which include PARENTHESIS (the default), BRACKET, DASH, and NONE resulting in (A), [A], -A-, and A (no enclosing characters), respectively; positioning of the TAG symbols with ABOVE (for above column text), BELOW (for below column text and above the column underline, the default), and SUB (below both the text and the underline); justification of the symbol with CENTER (centered, the default), LEFT (left-justified), or RIGHT (right-justified); SYMBOL n, where n is the nth TAG option symbol or string to use rather than the default, the first (or only) symbol. AUTOTAG will also function with EXCEL Run option, WORD and WORDALT options, although with some limitations to the positioning of the symbols.
COMP Table Option and HIGHLIGHTING of Significance Test Results: Optional highlighting of significance test results in output generated with either the EXCEL, WORD, or WORDALT Run Options. Significant cells will be filled with any color or shade on the gray scale.
FRAME Row Option: The FRAME row option enables the user to set up a “framework” table of rows that may be referenced and used by other tables in the same project. The rows in the frame table are written with symbols in the qualifications instead of data positions or fields, with the symbols a single number enclosed in brackets [ ]. A table referencing the frame table will supply a replacement value or values for the frame table’s symbol or symbols. The row in the active table having the FRAME option will be replaced by the frame table’s rows.
EXCEL Run Option and Significance Tests: Probability levels may now be exported to workbooks.
EXCEL Run Option and the NOMERGE Keyword: Added to optionally prevent the merging of row title cells.
EXCEL Run Option and the FIT Keyword: Will adjust the width of each banner point column to accommodate the longest word found in its title.
EXCEL Run Option and the BLANK Keyword: Added to optionally leave empty cells blank rather than forcing in zeroes.
EXCEL Run Option and Missing &WT Title Control Word: Now returns an error message and suppresses the output of that table to the workbook rather than terminating the run.
EXCEL Run Option and &WT Title Control Words with Text Exceeding 31 Characters: A warning message is now returned indicating the error, and displays how the truncated worksheet label now reads.
EXCEL Run Option and SET PLINE n: SET PLINE n is no longer required when the EXCEL Run Option is used.
EXCEL Run Option and Office 2007 Excel: A user’s Excel is now checked for its version. Any version equal to or greater than 12.0 (2007) will now result in a workbook extension of .xlsx.
NOWARNING Run Option: Will now additionally suppress the Attempt to divide by zero (in a row or column expression/in a table expression/in E-Qual), result set to zero warning messages, as well as significance test messages regarding effective base too small and insufficient data
SCALE Option and PC-Qualifications: May now be used with PC-Qualifications.
SZRCELL Option: This new option will suppress the contents of a single cell if its frequency count is less than or equal to the value set by the EPSILON option. May also be used with the PEPSILON option to suppress based on the cell’s percent.
VALUE Option and WEIGHT Tables: In WEIGHT tables, the VALUE option no longer requires a space between VALUE and the goal percent (e.g. V.25 is now acceptable)
RENUMBER Request: Tables may now be renumbered incrementally or decrementally rather than sequentially.
WRITE Request: The ALL keyword has been added to write all tables in the Table Library T-file to the Enter File E-file.
ERASE Request: The OFF keyword has been added to suppress the warning message dialog otherwise displayed that pauses the action and requires user confirmation.
EXECUTE and NODATA: IF statements will now be tested without the IF not run due to the nodata option message following each tested statement.
PAUSE Request: May be added to an executable table’s X-line to pause processing. When encountered, processing will halt until the user responds to the prompt, at which time processing will either resume or terminate.
SET QUAL and SET TITLE Requests: Notification symbols will appear on the Status Bar when either or both of these requests is active.
Columnize Entry in the Edit Panel of the Home Ribbon Tab: When using the UNCLE Editor to edit tables, Row and Column qualifications and options can be reordered into columns, resulting in an easy-to-read format that facilitates the writing or editing of a given table’s specifications. The Columnize action may be performed on all lines in the Editor, or a selected subset of contiguous lines.
and many more features.