LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2008, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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

Back to: Top of message | Previous page | Main SAS-L page