BookmarkSubscribeRSS Feed
Astounding
PROC Star

Are you able to post the actual log (not just the notes on the log) from the test you ran?  

 

I understand you may not be able to do that because of confidentiality reasons, but post what you can.

Astounding
PROC Star
Get rid of TAGSORT!
You only have 16 variables in the data set, and you need 13 of those as BY variables. So TAGSORT saves reading 3 variables but adds the need to pass through the data twice. As long as the sorting actually completes, removing TAGSORT should speed things up.
mariopellegrini
Pyrite | Level 9

even without TAGSORT the performance doesn't change much. even a little worse with the compressed dataset

Astounding
PROC Star

Wow!  Thank you for testing it.

 

That is so counter-intuitive (at least to me), that I wanted to confirm.  Was the test that you performed along these lines?

 

proc sort data=_16_variables out=test1;
   by list of _13_ variables;
run;

proc sort data=_16_variables out=test2 tagsort;
   by list of _13_ variables;
run;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 18 replies
  • 2858 views
  • 3 likes
  • 6 in conversation