topic How to Minimize execution time in Proc Sort in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/How-to-Minimize-execution-time-in-Proc-Sort/m-p/53971#M14953 <HTML><HEAD></HEAD><BODY><UL><LI>Proc Format is an alternative. </LI></UL><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://analytics.ncsu.edu/sesug/2001/P-605.pdf">http://analytics.ncsu.edu/sesug/2001/P-605.pdf</A></P><P></P><UL><LI> Index is another alternative.</LI></UL><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www2.sas.com/proceedings/sugi26/p121-26.pdf">http://www2.sas.com/proceedings/sugi26/p121-26.pdf</A></P><P></P><P>Go through those links. Those papers have lots of Info.</P></BODY></HTML> Tue, 03 Apr 2012 12:43:00 GMT Hima 2012-04-03T12:43:00Z How to Minimize execution time in Proc Sort https://communities.sas.com/t5/SAS-Procedures/How-to-Minimize-execution-time-in-Proc-Sort/m-p/53970#M14952 <HTML><HEAD></HEAD><BODY><P>..</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>Hi..</P><P></P><P>i have a large data set millions of records..</P><P></P><P>While sorting this dataset it taking too much of time for execution..</P><P></P><P>So is there any way to minimize the execution time????</P><P></P><P>Thanks</P><PRE __default_attr="xml" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><BR /></PRE> <PRE __default_attr="java" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><BR /></PRE> </PRE></BODY></HTML> Tue, 03 Apr 2012 12:32:41 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-Minimize-execution-time-in-Proc-Sort/m-p/53970#M14952 jontim 2012-04-03T12:32:41Z How to Minimize execution time in Proc Sort https://communities.sas.com/t5/SAS-Procedures/How-to-Minimize-execution-time-in-Proc-Sort/m-p/53971#M14953 <HTML><HEAD></HEAD><BODY><UL><LI>Proc Format is an alternative. </LI></UL><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://analytics.ncsu.edu/sesug/2001/P-605.pdf">http://analytics.ncsu.edu/sesug/2001/P-605.pdf</A></P><P></P><UL><LI> Index is another alternative.</LI></UL><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www2.sas.com/proceedings/sugi26/p121-26.pdf">http://www2.sas.com/proceedings/sugi26/p121-26.pdf</A></P><P></P><P>Go through those links. Those papers have lots of Info.</P></BODY></HTML> Tue, 03 Apr 2012 12:43:00 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-Minimize-execution-time-in-Proc-Sort/m-p/53971#M14953 Hima 2012-04-03T12:43:00Z Re: How to Minimize execution time in Proc Sort https://communities.sas.com/t5/SAS-Procedures/How-to-Minimize-execution-time-in-Proc-Sort/m-p/53972#M14954 <HTML><HEAD></HEAD><BODY><P>Yes You Can..</P><P></P><P>Go through this&nbsp; link...</P><P></P><P><A href="http://www2.sas.com/proceedings/sugi26/p121-26.pdf">http://www2.sas.com/proceedings/sugi26/p121-26.pdf</A></P></BODY></HTML> Tue, 03 Apr 2012 12:56:11 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-Minimize-execution-time-in-Proc-Sort/m-p/53972#M14954 kuridisanjeev 2012-04-03T12:56:11Z Re: How to Minimize execution time in Proc Sort https://communities.sas.com/t5/SAS-Procedures/How-to-Minimize-execution-time-in-Proc-Sort/m-p/53973#M14955 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 8pt; font-family: POKEN E+ Courier,Courier;"><STRONG style="font-size: 8pt; font-family: POKEN E+ Courier,Courier;">use the TAGSORT option in proc sort other than HASH,</STRONG></STRONG></P><P><STRONG style="font-size: 8pt; font-family: POKEN E+ Courier,Courier;"><STRONG style="font-size: 8pt; font-family: POKEN E+ Courier,Courier;"> </STRONG></STRONG></P><P><STRONG style="font-size: 8pt; font-family: POKEN E+ Courier,Courier;"><STRONG style="font-size: 8pt; font-family: POKEN E+ Courier,Courier;"><A href="http://www.lexjansen.com/phuse/2010/cc/cc03.pdf">http://www.lexjansen.com/phuse/2010/cc/cc03.pdf</A></STRONG></STRONG></P><P align="left"><SPAN style="font-size: 8pt; font-family: POKEN E+ Courier,Courier;"> </SPAN></P></BODY></HTML> Tue, 03 Apr 2012 14:10:05 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-Minimize-execution-time-in-Proc-Sort/m-p/53973#M14955 sassharp 2012-04-03T14:10:05Z