Date:         Mon, 22 Oct 2001 13:59:01 -0600
Reply-To:     jimcmi2@qwest.com
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         jimcmi2 <jimcmi2@QWEST.COM>
Subject:      Processing on Disk Note
Content-Type: text/plain; charset="iso-8859-1"

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 ;