Hi Kevin,

I can't recommend anything to you but you might want to see what I do and describe in my paper "Updating an MS SQL database from SAS": http://www.lexjansen.com/phuse/2010/cc/cc04.pdf http://home.hccnet.nl/jim.groeneveld/Recent/Summaries.shtml In there I DELETE a table's contents via Pass Through.

Regards - Jim. -- Jim Groeneveld, Netherlands Statistician/SAS consultant http://jim.groeneveld.eu.tf

On Mon, 1 Aug 2011 16:31:57 -0400, Viel, Kevin <kviel@SJHA.ORG> wrote:

>I have a MySQL table. The format is EAV. The table contains data for multiple projects that are distinguished by a project_id. The table is the redcap_data table for a REDCap project (www.project-redcap.org). > >I want to load census data into this table, but I want to erase the prior data every few days. I am accessing it in SAS using a DSN and the ODBC options to the LIBNAME statement. > >Would the best approach be to use the DELETE statement in the SQL procedure? If so, should I use a pass-through? Alternatively, I could use a data step. > >As a last resort, I could manually delete this data every week using REDCap. > >I would appreciate any comments. > >Thank you, > >Kevin > >Kevin Viel, PhD >Senior Research Statistician >Patient Safety & Quality >International College of Robotic Surgery >Saint Joseph's Translational Research Institute > >Saint Joseph's Hospital >5671 Peachtree Dunwoody Road, NE, Suite 330 >Atlanta, GA 30342 > >(678) 843-6076: Direct Phone >(678) 843-6153: Facsimile >(404) 558-1364: Mobile >kviel@sjha.org > > > > > >NOTICE: This e-mail message and all attachments transmitted with it may contain legally privileged and confidential information intended solely for the use of the addressee. In addition, this correspondence may contain private patient information protected under the federal privacy rule, 45 C.F.R. Parts 160 and 164, and applicable state law. Unauthorized use or disclosure of this information is strictly prohibited. If the reader of this message is not the intended recipient, you are hereby notified that any reading, dissemination, distribution, copying or other use of this message or its attachments is strictly prohibited. If you have received this message in error, please notify the sender immediately by return e-mail or at the telephone number above and delete the original message and all copies and backups thereof. Thank you > > >Confidentiality Notice: >This e-mail, including any attachments is the >property of Catholic Health East and is intended >for the sole use of the intended recipient(s). >It may contain information that is privileged and >confidential. Any unauthorized review, use, >disclosure, or distribution is prohibited. If you are >not the intended recipient, please delete this message, and >reply to the sender regarding the error in a separate email.