Date:         Mon, 31 Oct 2005 07:44:09 -0500
Reply-To:     "Srna, Carol (C.)" <csrna@FORD.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Srna, Carol (C.)" <csrna@FORD.COM>
Subject:      PROC SQL
Content-Type: text/plain; charset="us-ascii"

Hi All. What I want is to sum the GBS everytime the DSN variable
changes.  What I have is incorrect and I am not sure how to correct the
error.
                "ERROR: Invalid option name GBS."
I am researching.
Thanks for all you help.
~~Carol

  
                       DATA TEMP;                        
                  RETAIN GBS;                       
                  INPUT DSN $ 8-12 GBS 17-18;       
                  CARDS;                            
                     CAS      23                    
                     CAS      1                     
                     AABCC    40                    
                     XYZZZ    23                    
                     XYZZZ    33                    
                    JHHKK    14                    
                   JHHKK    15                    
                  ;                             
                      RUN;                 
     
                  PROC SORT DATA=TEMP OUT=TEMP1;   
                     BY DSN;                       
                         RUN;                             
         
         PROC SQL;                              
         CREATE TABLE DSNS AS                   
           SELECT DISTINCT GBS,DSN FROM TEMP1, 
           SUM(GBS);                           
   QUIT;