PROFILE command

Concept Information

Generates summary statistics for one or more numeric fields, or numeric expressions, in an Analytics table.

Syntax

PROFILE {<FIELDS> numeric_field <...n>|<FIELDS> ALL <EXCLUDE numeric_field <...n>>} <IF test> <WHILE test> <FIRST range|NEXT range>

Name	Description
FIELDS numeric_field <...n> \| FIELDS ALL	Specify individual fields to profile, or specify ALL to profile all numeric fields in the Analytics table.
EXCLUDE numeric_field optional	Only valid when profiling using FIELDS ALL. The field or fields to exclude from the command. EXCLUDE allows you to fine-tune FIELDS ALL, by excluding the specified fields. EXCLUDE must immediately follow FIELDS ALL. For example: FIELDS ALL EXCLUDE field_1 field_2
IF test optional	A conditional expression that must be true in order to process each record. The command is executed on only those records that satisfy the condition. Note The IF parameter is evaluated against only the records remaining in a table after any scope parameters have been applied (WHILE, FIRST, NEXT).
WHILE test optional	A conditional expression that must be true in order to process each record. The command is executed until the condition evaluates as false, or the end of the table is reached. Note If you use WHILE in conjunction with FIRST or NEXT, record processing stops as soon as one limit is reached.
FIRST range \| NEXT range optional	The number of records to process: FIRST start processing from the first record until the specified number of records is reached NEXT start processing from the currently selected record until the specified number of records is reached Use range to specify the number of records to process. If you omit FIRST and NEXT, all records are processed by default.

You profile the Salary field:

OPEN Employee_Payroll
PROFILE FIELDS Salary

The command generates the following output:

Field Name	Total Value	Absolute Value	Minimum	Maximum
SALARY	1,152,525	1,152,525	15,340	52,750

The following statistics are displayed for each numeric field or numeric expression specified for the command: