BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.

Hi Everyone,

We have mainframe jobs which runs monthly and have some proc sort part in program.
Sysout ID        Jobname     Jobid            Arch Date       Time

xxxxxx             xxxxxxxx    xxxxxxxx    03/10/2023    20:54

xxxxxx             xxxxxxxx    xxxxxxxx    04/09/2023    20:04


Upon investigating, found the below mentioned PROC SORT step executed long time this month,

Current month run:
---------------------------

MPRINT(txxxx):   proc sort data=xxx.abcd ;                      

MPRINT(xxxxx):   by var1 var2 ;                                          

MPRINT(xxxxx):   run ;                                                    

                                                                             

NOTE: There were 9953 observations read from the data set xxx.abcd.

NOTE: The data set xxx.abcd has 9953 observations and 26 variables.

NOTE: The PROCEDURE SORT used 2168.65 CPU seconds and 30027K.    

 

This sort step processing less than 10K records and the same sort step executed in 0.02 CPU Seconds in the previous month run.

Previous month run:
---------------------------

 

MPRINT(xxxxx):   proc sort data=xxx.abcd;                      

MPRINT(xxxxx):   by var1 var2 ;                                          

MPRINT(xxxxx):   run ;                                                    

                                                                             

NOTE: There were 9834 observations read from the data set xxx.abcd.

NOTE: The data set xxx.abcd has 9834 observations and 26 variables.

NOTE: The PROCEDURE SORT used 0.02 CPU seconds and 30027K.        

 

Could you please suggest reason for these issues, how can we troubleshoot. 

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

What about the rest of your job? Are there other PROC SORTs in your code? Did they run slowly too? What about other program steps - were any of those slower than normal? I seem to recall that doing host sorts is an option on mainframes. It could be your program was doing a host sort when it was extremely busy with other sorting jobs. If this is just a one-off occurence I wouldn't be too concerned. 

View solution in original post

1 REPLY 1
SASKiwi
PROC Star

What about the rest of your job? Are there other PROC SORTs in your code? Did they run slowly too? What about other program steps - were any of those slower than normal? I seem to recall that doing host sorts is an option on mainframes. It could be your program was doing a host sort when it was extremely busy with other sorting jobs. If this is just a one-off occurence I wouldn't be too concerned. 

sas-innovate-2024.png

📢

ANNOUNCEMENT

The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 4626 views
  • 3 likes
  • 2 in conversation