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
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.
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.