Data analysis specification

File-AID/Data Solutions displays the Data Analysis Specification window, shown in the following figure, when you use the EX relational operator on the Data Analysis Criteria screen. It allows you to specify the parameters to use for each field in the data analysis. 

Data Analysis Specification Screen

Field Descriptions

Field Name

Name of selected field as defined by the record layout.

Data Type

Data type of selected field as defined by the record layout.

Length

Length of data in selected field as defined by the record layout. This field may be overtyped to shorten or lengthen the length of data to analyze. This is particularly useful when you want to analyze all the elements of a group item.

Date Pattern

When analyzing a date field, specify a date pattern in this field. Enter an asterisk to display a list of available date patterns.

Specify Analysis Options:

Statistics Report

Specify whether you want the statistics report included in the Data Analysis report. Valid values are Y (Yes -- default) or N (No). The statistics report provides the number of unique values and valid values and includes the statistics and values for highest, lowest, most common, average, and median values.

Occurrences Report

Specify whether you want the occurrences report included in the Data Analysis report. The occurrence report lists the number of times each value occurs and provides each value. When F is specified, only the values listed in the filter dataset table are analyzed for the occurrence report. Valid values are:

Maximum Occurrences

Specify the maximum unique occurrences to report. The default is ALL which reports all unique occurrences.

If Option F, specify dataset name and location below: When you Specify F in the Occurrence Report field, you must provide the following information regarding the filter dataset table:

Data set

Specify the name of the filter table dataset.

Member

Specify the member name of the filter table.

Location

Location of the analysis data in the table.

Data Type

Type of data at the specified location in the filter dataset table.

Valid entries are:

• 
  
  • CHAR (Character)
  • VCHR (Variable length Character)
  • NUM (Numeric)
  • BIN (Binary)
  • HEX (Hexadecimal)
  • PS (Packed Signed)
  • DBCS (Double Byte Character Set)
  • VDBC (Variable length Double Byte Character Set)

This data type does not have to match the field’s data type as defined by the record layout.

Length

Length of data in table dataset. The default is the input field length.

Primary Commands

The following primary commands are valid:

END

Saves the entered parameters and returns to the Data Analysis Criteria screen.

CANCEL

Discards the entries and returns to the Data Analysis Criteria screen.