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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.