Date:         Fri, 30 Aug 2002 09:24:08 -0400
Reply-To:     "Abakah Nori (crm1nxa)" <crm1nxa@UPS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Abakah Nori (crm1nxa)" <crm1nxa@UPS.COM>
Subject:      Efficiency coding - Base
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: multipart/alternative;

Hi all,

I need some ideas on how to get this code to be more efficient. Once upon a
time, the input dataset contained < 1,000,000 obs so efficiency may not have
been top priority.  Now, with > 14,000,000 obs, CPU time has sky rocketed.

Any ideas will be greatly appreciated.

Thanks
Nori

13           DATA LPARIN;

14                SET LPARIN.CICSTRAN;

                                                           THE SAS SYSTEM



15                KEEP APPLID TRANNAME IRESPTM SYSTEM TASCPUTM TDTOTCN
TSTOTCN
16                     FCTOTCN SUSPNDTM TASDSPTM WTDISPTM WTTCIOTM UOWTIME
TASKNR
17                     TCLASS HOUR DATE;

18                HOUR=HOUR(TIMEPART(STRTTIME));

19                DATE=DATEPART(STRTTIME);

20                IF PROGRAM='########' THEN DELETE;

21



NOTE: THERE WERE 14778806 OBSERVATIONS READ FROM THE DATA SET
LPARIN.CICSTRAN.
NOTE: THE DATA SET WORK.LPARIN HAS 14774629 OBSERVATIONS AND 17 VARIABLES.

NOTE: COMPRESSING DATA SET WORK.LPARIN DECREASED SIZE BY 1.99 PERCENT.

      COMPRESSED IS 42591 PAGES; UN-COMPRESSED WOULD REQUIRE 43455 PAGES.

NOTE: THE DATA STATEMENT USED 387.00 CPU SECONDS AND 11071K.



22           PROC SORT;
23                BY APPLID TRANNAME TASKNR UOWTIME DATE HOUR;
24

NOTE: THERE WERE 14774629 OBSERVATIONS READ FROM THE DATA SET WORK.LPARIN.
NOTE: THE DATA SET WORK.LPARIN HAS 14774629 OBSERVATIONS AND 17 VARIABLES.
NOTE: COMPRESSING DATA SET WORK.LPARIN DECREASED SIZE BY 1.99 PERCENT.
      COMPRESSED IS 42589 PAGES; UN-COMPRESSED WOULD REQUIRE 43455 PAGES.
NOTE: THE PROCEDURE SORT USED 220.58 CPU SECONDS AND 11163K.

25           PROC MEANS NOPRINT;
26                BY APPLID TRANNAME TASKNR UOWTIME DATE HOUR SYSTEM;
27                ID TCLASS;
28                OUTPUT OUT=LPARIN
29                SUM=IRESPTM TASCPUTM TDTOTCN TSTOTCN FCTOTCN
30                    SUSPNDTM TASDSPTM WTDISPTM WTTCIOTM;
31                VAR IRESPTM TASCPUTM TDTOTCN TSTOTCN FCTOTCN
32                    SUSPNDTM TASDSPTM WTDISPTM WTTCIOTM;

NOTE: THERE WERE 14774629 OBSERVATIONS READ FROM THE DATA SET WORK.LPARIN.
NOTE: THE DATA SET WORK.LPARIN HAS 14159741 OBSERVATIONS AND 19 VARIABLES.
NOTE: COMPRESSING DATA SET WORK.LPARIN DECREASED SIZE BY 32.10 PERCENT.
      COMPRESSED IS 46448 PAGES; UN-COMPRESSED WOULD REQUIRE 68405 PAGES.
NOTE: THE PROCEDURE MEANS USED 899.87 CPU SECONDS AND 11499K.

=========================
Abakah, Nori
Capacity & Performance Analyst
United Parcel Service
(201) 828-2351


[text/html]