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 **** >---------------------------------------------------

Yes, correct. DEMOGRAPHIC is a table in your ACCESS database. With ODBC you cannot REPLACE it with the output from SAS. However you should be able to update a existing table. I don't know the ODBC access very good, but most of the SAS/ACCESS modules allow update to records of a database table. I don't know any ACCESS module which allows replacing a database table. On most databases you can create a table and load it with data, but not simply overwrite it.