Date: Tue, 5 Oct 2004 17:33:54 -0700
Reply-To: Tony Wang <tonywolf@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Tony Wang <tonywolf@YAHOO.COM>
Subject: What is wrong with this sql join?
Content-Type: text/plain; charset=ISO-8859-1
16 proc sql;
17 create table x.txunos_041005 as
18 select * from x.txunos_041005 a left join x.mbr_1 b on
19 a.trr_id=b.trrid and a.usrds_id=b.usrds_id;
ERROR: Integer divide by zero.
NOTE: The SAS System stopped processing this step because of errors.
ERROR: Read Access Violation In Task ( SQL ]
Exception occurred at (67E691D3)
What is wrong? nobody was reading that file.
How come "Integer divide by zero."?