ISSUE WITH - NOTE: The PROCEDURE SORT used XXXX CPU seconds and XXXXK.

kumarsandip975 — Thu, 19 Oct 2023 18:57:54 GMT

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.

Re: ISSUE WITH - NOTE: The PROCEDURE SORT used XXXX CPU seconds and XXXXK.

SASKiwi — Thu, 19 Oct 2023 19:17:02 GMT

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.

topic ISSUE WITH - NOTE: The PROCEDURE SORT used XXXX CPU seconds and XXXXK. in SAS Programming

ISSUE WITH - NOTE: The PROCEDURE SORT used XXXX CPU seconds and XXXXK.

Re: ISSUE WITH - NOTE: The PROCEDURE SORT used XXXX CPU seconds and XXXXK.