I receive the note below during a monthly processing job. Typically, I ignore the message because the job runs over the weekend. However, if I am missing something that could decrease the processing time it would be great to fix it.

NOTE: Processing on disk occurred during summarization. Peak disk usage was approximately 1094 Mbytes. Adjusting SUMSIZE may improve performance.

The process is a PROC SUMMARY on a very large dataset, with a class statement as below.

I realize I could use a by statement if the dataset was sorted, but this is much slower than using the class statement on an un-sorted file.

Thanks, any help is much appreciated. Jim

proc summary data=churnscr.wccc_sum_contact_type_sets ; VAR OTHER_PCT OTHER_CNT ROAMING_PCT ROAMING_CNT SERVICE_PCT SERVICE_CNT NETWORK_PCT NETWORK_CNT FEATURE_PCT FEATURE_CNT EQUIP_PCT EQUIP_CNT DEAD_AIR_PCT DEAD_AIR_CNT BILLING_CC_PCT BILLING_CC_CNT ACCESSOR_PCT ACCESSOR_CNT DEACT_SAVE_PCT DEACT_SAVE_CNT BILLING_MOU_PCT BILLING_MOU_CNT TROUBLESHOOT_PCT TROUBLESHOOT_CNT SVC_EQ_INF_PCT SVC_EQ_INF_CNT ORDER_STATUS_PCT ORDER_STATUS_CNT ; CLASS ACCT_NUM ; OUTPUT OUT=churnscr.Wccc_sum_contact_type_fin MEAN=OTHER_PCT OTHER_CNT ROAMING_PCT ROAMING_CNT SERVICE_PCT SERVICE_CNT NETWORK_PCT NETWORK_CNT FEATURE_PCT FEATURE_CNT EQUIP_PCT EQUIP_CNT DEAD_AIR_PCT DEAD_AIR_CNT BILLING_CC_PCT BILLING_CC_CNT ACCESSOR_PCT ACCESSOR_CNT DEACT_SAVE_PCT DEACT_SAVE_CNT BILLING_MOU_PCT BILLING_MOU_CNT TROUBLESHOOT_PCT TROUBLESHOOT_CNT SVC_EQ_INF_PCT SVC_EQ_INF_CNT ORDER_STATUS_PCT ORDER_STATUS_CNT ; run ;