Process Help

RANK - generate rank orders for a given field

 

Process Name

Menu Path

Link to Command Table

RANK

Click here

 

Introduction

Ranks values of a given numeric or alphanumeric field in a file.


Files, Fields and Parameters

Input Files

Name

Description

I/O Status

Required

Type

IN

Input file.

Input

Yes

Undefined

Output Files

Name

I/O Status

Required

Type

Description

OUT

Output

Yes

Undefined

Output file.

Fields

Name

Description

Source

Required

Type

Default

VALUE

Numeric or up to 4-character alpha field to be ranked.

IN

Yes

Any

Undefined

RANK

New field to be created in output file, to contain rank order values.

OUT

Yes

Undefined

Undefined

CUMPROP

New field to be created in output file, to contain cumulative frequency values of field RANK [values of CUMPROP lie between 0 and 1].

OUT

Yes

Numeric

Undefined

PHI

New field to be created in output file, to contain PHI [inverse normal distribution] transform of field CUMPROP [values of PHI lie between -3.5 and +3.5].

OUT

Yes

Numeric

Undefined


Notes

Output fields created are as follows:

RANK:Rank order (integer) of the specified field.

CUMPROP:Proportion value, computed as (RANK-0.5)/NDATA where NDATA is the number of data records used.

PHI: The standard normal deviate, computed as the PHI (or Z) transform of the CUMPROP value. PHI is centred on zero and has values in the range -3.5 to +3.5 for small data sets.


Example

!RANK

 &IN(SEDREG),&OUT(SRANK),

*VALUE(AU),*RANK(ORDER),*CUMPROP(AUCF),*PHI(AUPHI)


Error and Warning Messages

Message

Description

Solution

>>> ERR 120 <<< ( fileno) IN ffffffff

Input file ffffffff read error. Fatal; the process is exited.

 

 

 

 

>>> ERR 121 <<< ( fileno) IN RANK

File read error. Fatal; the process is exited.

 

 

 

 

>>> ERR 122 <<< ( fileno) IN RANK

 

No numeric fields in file, or fields specified were not numeric. Fatal; the process is exited.