Help using Base SAS procedures

How to Minimize execution time in Proc Sort

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

How to Minimize execution time in Proc Sort

..

Hi..

i have a large data set millions of records..

While sorting this dataset it taking too much of time for execution..

So is there any way to minimize the execution time????

Thanks




Accepted Solutions
Solution
‎04-03-2012 08:56 AM
Super Contributor
Posts: 276

Re: How to Minimize execution time in Proc Sort


All Replies
Regular Contributor
Posts: 233

How to Minimize execution time in Proc Sort

  • Proc Format is an alternative.

                      http://analytics.ncsu.edu/sesug/2001/P-605.pdf

  • Index is another alternative.

                     http://www2.sas.com/proceedings/sugi26/p121-26.pdf

Go through those links. Those papers have lots of Info.

Solution
‎04-03-2012 08:56 AM
Super Contributor
Posts: 276

Re: How to Minimize execution time in Proc Sort

Yes You Can..

Go through this  link...

http://www2.sas.com/proceedings/sugi26/p121-26.pdf

Frequent Contributor
Posts: 110

Re: How to Minimize execution time in Proc Sort

use the TAGSORT option in proc sort other than HASH,

http://www.lexjansen.com/phuse/2010/cc/cc03.pdf

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 2998 views
  • 3 likes
  • 4 in conversation