Date:         Mon, 27 Aug 2007 19:52:32 -0700
Reply-To:     Danger <atul.upadh@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Danger <atul.upadh@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Simple PROC SQL help
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hi everyone,
what am I doing wrong here. Can someone throw some light. It must me
pretty easy stuff for you folks.
Thanks

   proc sql noprint;
   title 'Bkg and ERP pos';
   create table test.table1 as
   select * from test.new1, test.new2
   where new1.END_CUSTOMER_PARTY_KEY
   = new2.END_CUSTOMER_PARTY_KEY;
quit;
It gives me the following warning:

WARNING: Variable END_CUSTOMER_PARTY_KEY already exists on file
TEST.TABLE1.
NOTE: Table TEST.TABLE1 created, with 47 rows and 6 columns.


NOTE: PROCEDURE SQL used (Total process time):
      real time           28.28 seconds
      cpu time            0.10 seconds