Date:         Tue, 15 Oct 2002 13:36:02 -0400
Reply-To:     Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject:      Re: A little clarification on an error message ....

On Tue, 15 Oct 2002 13:14:12 -0400, Cacialli, Doug
<Doug_Cacialli@URMC.ROCHESTER.EDU> wrote:

>Y'all,
>
>When trying to run the following code:
>
>LIBNAME MIRROR ODBC REQUIRED="DRIVER={MICROSOFT ACCESS DRIVER (*.MDB)};
>                                        DBQ=H:\GILES RESEARCH - MIRROR.MDB;
>                                        SYSTEMDB=S:\DEPRESSION
>RESEARCH\SECURED.MDW;
>                                        UID=Doug Cacialli;
>                                        PWD=MYPASSWORD;";
>
>PROC SORT DATA = MIRROR.DEMOGRAPHIC;
>BY ID;
>DATA DEMO_ID;
>        SET MIRROR.DEMOGRAPHIC;
>        BY ID;
>IF FIRST.ID = 1;
>KEEP ID;
>RUN;
>
>I get the following error:
>
>ERROR: The ODBC table DEMOGRAPHIC has been opened for OUTPUT. This table
>already
>exists, or there is a name conflict with an existing object. This table
will
>not
>be replaced. This engine does not support the REPLACE option.
>
>I'm assuming that this means that I can't use ODBC to modify the data in
>SAS.  Is
>this correct?  If it's not correct, can someone tell me what it does mean?
>Thanks for the help.
>
>Doug out.
>
>---------------------------------------------------
>Douglas Cacialli - Data Analyst / Programmer
>Depression Research Laboratory
>University of Rochester Medical Center
>300 Crittenden Blvd. - Box PSYCH
>Rochester, New York 14642
>Phone: (585)273-3309          Fax: (585)506-0287
>****   NOTE NEW FAX NUMBER   ****
>---------------------------------------------------


uups, sent it too fast! Sorry!

what you do with your proc sort is: sort the data which is in data= and
write it back to itselve (because you have no OUT= parameter.
Its very easy to get it to work:

use
proc sort data=mirror.demographic out=temp;
  by....
run;

and continue with TEMP.