BookmarkSubscribeRSS Feed
norman24
Calcite | Level 5
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?
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 883 views
  • 0 likes
  • 2 in conversation