Date:         Mon, 21 Jan 2008 22:53:31 -0500
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: =?gb2312?Q?=B4=F0=B8=B4:?= What's wrong with that??? (libname
              statement with pc files formats)
Content-Type: text/plain; charset=ISO-8859-1

On Sun, 20 Jan 2008 22:46:57 -0500, Howard Schreier <hs AT dc-sug DOT org>
<nospam@HOWLES.COM> wrote:

>On Mon, 21 Jan 2008 08:41:29 +0800, Yuntao_Dou (BJ) <Yuntao_Dou@SMICS.COM>
>wrote:
>
>>that is really weird.
>>
>>I run the below code in SAS9.1(just substitute mydb.delme with work.delme).
> And the answer is correct!
>>
>>data delme;
>>do x=1 to 1000; output;end;
>>run;
>>
>>
>>proc sql;
>>delete * from delme
>>where x >10;
>>select count(*) as nb from delme
>>where x >10;
>>quit;
>>
>>Below is the output:
>>
>>nb
>
>Yet I was able to replicate Alex's strange result. I am running 9.1.3, but I
>recently had to re-install and I don't think I grabbed all of the service
>packs. I suspect that is where the explanation lies.

Ignore that; I did not read carefully. Yuntao missed the point and used the
default engine rather than the MS Access engine; results are not germane.

>
>>--------
>>0
>>
>>-----ԭʼ�ʼ�-----
>>������: SAS(r) Discussion [mailto:SAS-L@LISTSERV.VT.EDU]��� Arthur
>>Tabachneck
>>����ʱ��: 2008��1��21�� 7:49
>>�ռ���: SAS-L@LISTSERV.VT.EDU
>>����: Re: What's wrong with that??? (libname statement with pc files
>>formats)
>>
>>
>>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