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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.