Data analysis report
The Data Analysis function creates the Data Analysis report, which is divided into the following informational sections:
Statistics Report
Reports the number of unique values, number of valid values, and the range of values found in the selected field.
Occurrence report
Reports each unique value and the number of times each value occurs within the selected field.
Invalid Data Report
Reports whether invalid data was found in the selected field. When invalid data is found, Data Solutions lists the number of invalid values and the highest, lowest, and most common invalid value found.
Data Analysis Report
SET 1 DATA-====================================================================================
SET 1 DATA-DATA ANALYSIS FOR FIELD EMP-HOME-AREA-CODE RECORDS ANALYZED __________50
SET 1 DATA-
SET 1 DATA-----STATISTICS REPORT---------------------------------------------------------------
SET 1 DATA-SIGN = N DATE PATTERN =
SET 1 DATA- ----COUNT--- ----DESCRIPTION---- ---------------F I E L D V A L U E---------------
SET 1 DATA- __________14 UNIQUE VALUES
SET 1 DATA- __________43 -VALID- VALUES
SET 1 DATA- ___________1 HIGHEST ______________________909
SET 1 DATA- ___________1 LOWEST ______________________111
SET 1 DATA- __________10 MOST COMMON ______________________408
SET 1 DATA- AVERAGE ______________________417
SET 1 DATA- __________10 MEDIAN ______________________408
SET 1 DATA-
SET 1 DATA-----OCCURRENCE REPORT---------------------------------------------------------------
SET 1 DATA-SIGN = N DATE PATTERN =
SET 1 DATA- ----COUNT--- ----DESCRIPTION---- ---------------F I E L D V A L U E---------------
SET 1 DATA- __________14 UNIQUE VALUES
SET 1 DATA- __________43 -VALID- VALUES
SET 1 DATA- __________10 TIME(S) ______________________408
SET 1 DATA- ___________6 TIME(S) ______________________312
SET 1 DATA- ___________4 TIME(S) ______________________215
SET 1 DATA- ___________4 TIME(S) ______________________404
SET 1 DATA- ___________3 TIME(S) ______________________212
SET 1 DATA- ___________2 TIME(S) ______________________415
SET 1 DATA- ___________7 OCCURRENCES BYPASSED, NOT IN FILTER DATASET
SET 1 DATA-
SET 1 DATA-----INVALID DATA REPORT----------------------------------------------------------
SET 1 DATA- ___________7 INVALID VALUES
SET 1 DATA- ___________7 HIGHEST
SET 1 DATA- POS. 1-003
SET 1 DATA- ZONE 444
SET 1 DATA- NUMR 000
SET 1 DATA- ___________7 LOWEST
SET 1 DATA- POS. 1-003
SET 1 DATA- ZONE 444
SET 1 DATA- NUMR 000
SET 1 DATA- ___________7 MOST COMMON
SET 1 DATA- POS. 1-003
SET 1 DATA- ZONE 444
SET 1 DATA- NUMR 000
SET 1 DATA-
SET 1 DATA-=================================================================================
SET 1 DATA-Records Read 50, Selected 50, Fields Processed 43, Invalid 7
SET 1 DATA-DATA ANALYSIS FOR FIELD EMP-HOME-AREA-CODE RECORDS ANALYZED __________50
SET 1 DATA-
SET 1 DATA-----STATISTICS REPORT---------------------------------------------------------------
SET 1 DATA-SIGN = N DATE PATTERN =
SET 1 DATA- ----COUNT--- ----DESCRIPTION---- ---------------F I E L D V A L U E---------------
SET 1 DATA- __________14 UNIQUE VALUES
SET 1 DATA- __________43 -VALID- VALUES
SET 1 DATA- ___________1 HIGHEST ______________________909
SET 1 DATA- ___________1 LOWEST ______________________111
SET 1 DATA- __________10 MOST COMMON ______________________408
SET 1 DATA- AVERAGE ______________________417
SET 1 DATA- __________10 MEDIAN ______________________408
SET 1 DATA-
SET 1 DATA-----OCCURRENCE REPORT---------------------------------------------------------------
SET 1 DATA-SIGN = N DATE PATTERN =
SET 1 DATA- ----COUNT--- ----DESCRIPTION---- ---------------F I E L D V A L U E---------------
SET 1 DATA- __________14 UNIQUE VALUES
SET 1 DATA- __________43 -VALID- VALUES
SET 1 DATA- __________10 TIME(S) ______________________408
SET 1 DATA- ___________6 TIME(S) ______________________312
SET 1 DATA- ___________4 TIME(S) ______________________215
SET 1 DATA- ___________4 TIME(S) ______________________404
SET 1 DATA- ___________3 TIME(S) ______________________212
SET 1 DATA- ___________2 TIME(S) ______________________415
SET 1 DATA- ___________7 OCCURRENCES BYPASSED, NOT IN FILTER DATASET
SET 1 DATA-
SET 1 DATA-----INVALID DATA REPORT----------------------------------------------------------
SET 1 DATA- ___________7 INVALID VALUES
SET 1 DATA- ___________7 HIGHEST
SET 1 DATA- POS. 1-003
SET 1 DATA- ZONE 444
SET 1 DATA- NUMR 000
SET 1 DATA- ___________7 LOWEST
SET 1 DATA- POS. 1-003
SET 1 DATA- ZONE 444
SET 1 DATA- NUMR 000
SET 1 DATA- ___________7 MOST COMMON
SET 1 DATA- POS. 1-003
SET 1 DATA- ZONE 444
SET 1 DATA- NUMR 000
SET 1 DATA-
SET 1 DATA-=================================================================================
SET 1 DATA-Records Read 50, Selected 50, Fields Processed 43, Invalid 7
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*