Date:         Fri, 20 Oct 2000 15:58:26 +0200
Reply-To:     albert.venetitay@CTICEP.CAISSE-EPARGNE.FR
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         albert.venetitay@CTICEP.CAISSE-EPARGNE.FR
Subject:      sql temporary work file
Content-type: text/plain; charset=iso-8859-1

  HI all ,

    I'm getting the message ' proc sql temporary work file has grown'
inspite of increasing my work file ?
    Does anybody knows what is going wrong with this program ?
    Does  the sql temporary file uses  the same allocation of the work
file,  or it uses some internal sort work files ?
    Can anybody in this list , have seen this problem  and could  share
their experiences ?
     Thanks a lot.
     Any help and suggestions will  be greatly  appreciated ?

   Thanks in advance ,
    Kind regards ,
   Albert Venetitay


Following is the code and the proc contents of the file  .


 13        +

14        +CREATE TABLE USAGE.TEMP AS
15        +SELECT DISTINCT A.NUPERS,A.CDNIVS1,B.DTCON FORMAT=DDMMYY10.
16        +FROM FF A,STATG1.P_AGENDA B
17        +WHERE A.NUCCOM=B.NUCCOM
18        +AND B.CNCON='AGE'
19        +AND '30SEP2000'D >= B.DTCON >= '01OCT1999'D;
NOTE: PROC SQL TEMPORARY WORK FILE HAS GROWN TOO LARGE.
NOTE: TABLE USAGE.TEMP CREATED, WITH 0 ROWS AND 3 COLUMNS.



                    CONTENTS PROCEDURE

 PDBOUT.P_AGENDA                          OBSERVATIONS:         2596476
 DATA
VARIABLES:            8
 V609

INDEXES:              1
 5:05 WEDNESDAY, OCTOBER 4, 2000          OBSERVATION LENGTH:   59
 14:30 FRIDAY, OCTOBER 20, 2000                  DELETED OBSERVATIONS: 0

                                          COMPRESSED:           YES
                                          REUSE SPACE:          NO
                                          SORTED:               NO



____________________________________________

CTICEP
40, avenue Jean Jaurès
93176 Bagnolet Cedex

Albert VENETITAY

E-Mail : albert.venetitay@cticep.caisse-epargne.fr
ou   : ave@cticep.caisse-epargne.fr