Date:         Sun, 5 Oct 2008 19:41:07 -0400
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: proc sql & updating
Comments: To: "Mark S." <marksmolkin@GMAIL.COM>
In-Reply-To:  <200810032205.m93I0c00010777@malibu.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Mark:
Autonumber ID attributes introduce a number of complications, but, in general, those problems arise only when you try to insert an autonumber values or update one. The SGF 2008 paper by Hermansen, Singh, and Hrycyk explains much of what I know about autonumbers. Once a database has an autogenerated value for an key ID in a tuple, you should be to identify the tuple in which you wish to update an attribute other than the key ID.
S

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Mark S.
Sent: Friday, October 03, 2008 6:05 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: proc sql & updating


It seems like the update might be failing because the table containing the field I am attempting to update has an ID field that is 'autonumber'. Note that this ID field is referenced in the 'where' statement of the correlated subquery. Anybody know why this would occur?....Thanks..

Mark