Date:         Sun, 20 Jan 2008 18:49:25 -0500
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: What's wrong with that??? (libname statement with pc files
              formats)
Comments: To: alx_32@HOTMAIL.COM

Alex,

I would think that this qualifies as an actual bug that I hope would be
corrected quite quickly.

Art
-------
On Sun, 20 Jan 2008 14:57:37 -0800, Alex_fr <alx_32@HOTMAIL.COM> wrote:

>Hi there,
>
>I create in the access file  'c:\temp\db2.mdb' a table with 1000 rows
>with a variable x=1,..,1000.
>I tried to delete the rows for witch x >10. Only the rows x=11 and
>x=12 are deleted!!
>
>libname mydb 'c:\temp\db2.mdb';
>
>data mydb.delme;
> do x=1 to 1000; output;end;
> run;
>
>NOTE: The data set MYDB.delme has 1000 observations and 1 variables.
>
>
>
>
> proc sql;
> delete * from mydb.delme
> where x >10;
> select count(*) as nb from mydb.delme
> where x >10;
>
>NOTE: 2 rows were deleted from MYDB.delme. (!!!!!!)
>
>        nb
>-----------------
>         988
>
>Can anyone explain me what is this stange behaviour?
>
>Thanks in advance
>Alexandre