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 (October 2002, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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.

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