Load Dataset to a truncated Oracle Table

norman24 — Mon, 23 Mar 2009 18:02:57 GMT

We need to load data to a truncated Oracle table and I am unfamiliar with how to do this. We have already established a connection with Oracle and have had success deleting and loading to a table but how do we load to the table without deleting it and re-creating it each time? Do we accomplish this by doing a proc append? Suggestions?

Re: Load Dataset to a truncated Oracle Table

sbb — Mon, 23 Mar 2009 20:30:39 GMT

SAS support website http://support.sas.com/ SEARCH facility has several technical documents and conference papers on this topic - also, I did a Google advanced using the argument below to find reference items related to your post:

append sas data to oracle table site:sas.com

However, there is at least one SAS TECHNOTE with a related HOTFIX - see link below, in case it may apply:

Problem Note 16338: Using PROC APPEND to insert rows into an Oracle table may report an error as a note
http://support.sas.com/kb/16/338.html

Scott Barry
SBBWorks, Inc.

topic Re: Load Dataset to a truncated Oracle Table in SAS Procedures

Load Dataset to a truncated Oracle Table

Re: Load Dataset to a truncated Oracle Table