DATA Step, Macro, Functions and more

Not Sorted option.

Reply
Contributor
Posts: 29

Not Sorted option.

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

Super User
Posts: 5,428

Re: Not Sorted option.

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.

Data never sleeps
Super User
Super User
Posts: 7,950

Re: Not Sorted option.

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.

Ask a Question
Discussion stats
  • 2 replies
  • 180 views
  • 0 likes
  • 3 in conversation