Not Sorted option.

[Chikku]

Hi,

Can anyone explain me what is the purpose of notsorted option and in which situation i should make use of it.

Kindly let me know your thoughts.

Thank you.

karthik

[LinusH]

If you know that your data is sorted, but not in a pre-defined sorting sequence (such as ASCII, ANSI etc).

I.e. month names.

The benefit is that you still will be able to use BY group processing in the data step/PROCs.

[RW9]

Hi,

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Notsorted is for when data is grouped logically, but not necessarily in alphabetic or numeric order.  I.e.

B

B

B

A

A

C

C

The data A is grouped together but is not sequential to B.