Help using Base SAS procedures

Load Dataset to a truncated Oracle Table

Reply
N/A
Posts: 1

Load Dataset to a truncated Oracle Table

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?
Super Contributor
Super Contributor
Posts: 3,174

Re: Load Dataset to a truncated Oracle Table

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.
Ask a Question
Discussion stats
  • 1 reply
  • 87 views
  • 0 likes
  • 2 in conversation