topic Re: Not Sorted option. in SAS Programming https://communities.sas.com/t5/SAS-Programming/Not-Sorted-option/m-p/205610#M38237 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Hi,</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"><A class="active_link" href="http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000202968.htm" style="font-size: 10pt;" title="http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000202968.htm">SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition</A></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Notsorted is for when data is grouped logically, but not necessarily in alphabetic or numeric order.&nbsp; I.e.</P><P style="font-size: 13.3333330154419px;">B</P><P style="font-size: 13.3333330154419px;">B</P><P style="font-size: 13.3333330154419px;">B</P><P style="font-size: 13.3333330154419px;">A</P><P style="font-size: 13.3333330154419px;">A</P><P style="font-size: 13.3333330154419px;">C</P><P style="font-size: 13.3333330154419px;">C</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">The data A is grouped together but is not sequential to B.</P></BODY></HTML> Thu, 19 Mar 2015 09:29:31 GMT RW9 2015-03-19T09:29:31Z Not Sorted option. https://communities.sas.com/t5/SAS-Programming/Not-Sorted-option/m-p/205608#M38235 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone explain me what is the purpose of <SPAN style="font-size: 14pt;">notsorted <SPAN style="font-size: 10pt;">option and in which situation i should make use of it.</SPAN></SPAN></P><P></P><P>Kindly let me know your thoughts.</P><P></P><P>Thank you.</P><P>karthik</P></BODY></HTML> Thu, 19 Mar 2015 09:05:06 GMT https://communities.sas.com/t5/SAS-Programming/Not-Sorted-option/m-p/205608#M38235 Chikku 2015-03-19T09:05:06Z Re: Not Sorted option. https://communities.sas.com/t5/SAS-Programming/Not-Sorted-option/m-p/205609#M38236 <HTML><HEAD></HEAD><BODY><P>If you know that your data is sorted, but not in a pre-defined sorting sequence (such as ASCII, ANSI etc).</P><P>I.e. month names.</P><P>The benefit is that you still will be able to use BY group processing in the data step/PROCs.</P></BODY></HTML> Thu, 19 Mar 2015 09:24:07 GMT https://communities.sas.com/t5/SAS-Programming/Not-Sorted-option/m-p/205609#M38236 LinusH 2015-03-19T09:24:07Z Re: Not Sorted option. https://communities.sas.com/t5/SAS-Programming/Not-Sorted-option/m-p/205610#M38237 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Hi,</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"><A class="active_link" href="http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000202968.htm" style="font-size: 10pt;" title="http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000202968.htm">SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition</A></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Notsorted is for when data is grouped logically, but not necessarily in alphabetic or numeric order.&nbsp; I.e.</P><P style="font-size: 13.3333330154419px;">B</P><P style="font-size: 13.3333330154419px;">B</P><P style="font-size: 13.3333330154419px;">B</P><P style="font-size: 13.3333330154419px;">A</P><P style="font-size: 13.3333330154419px;">A</P><P style="font-size: 13.3333330154419px;">C</P><P style="font-size: 13.3333330154419px;">C</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">The data A is grouped together but is not sequential to B.</P></BODY></HTML> Thu, 19 Mar 2015 09:29:31 GMT https://communities.sas.com/t5/SAS-Programming/Not-Sorted-option/m-p/205610#M38237 RW9 2015-03-19T09:29:31Z