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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 4728 views
  • 3 likes
  • 2 in conversation