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":
In there I DELETE a table's contents via Pass Through.
Regards - Jim.
Jim Groeneveld, Netherlands
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.
>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
>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
>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.