BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jontim
Calcite | Level 5

..

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



1 ACCEPTED SOLUTION

Accepted Solutions
3 REPLIES 3
Hima
Obsidian | Level 7
  • 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.

sassharp
Calcite | Level 5

use the TAGSORT option in proc sort other than HASH,

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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