Whenever i perform any task like deletion, merging / joining / sub-setting, the performance of a sorted array is faster than than unsorted array, Has any one else experienced it?
If it is true, why does this happen? Does SAS perform any sorting / Indexing and if it is already done then it takes lesser time? Should we sort the data always and then perform other operations?
Please help me to understand it better.