title: Updating an Oracle table with data from a SAS data set using SAS code
body: <p>I am rather new to SAS and I have run into a problem that I think probably has a better solution than what I've found so far. </p>
  
  <p>I need to update a Oracle db table that has around 1 million rows with data from a SAS data set that has about 10,000 records. </p>
  
  <p>I used an update statement within proc sql, but it takes hours to update the Oracle table. Right now, I am loading the data from the SAS data set into a temporary table in the Oracle db and doing a proc sql pass through execute statement to update the main table from the temporary table. This takes only a couple of minutes at most. </p>
  
  <p>However, this is rather cumbersome to program and and I need to update the Oracle table from multiple functions within my SAS code. </p>
  
  <p>Is there an analog to JDBC batch update in SAS (I uses to do Java programming before getting involved in SAS)? Something that is faster than using an update statement in proc sql, but easier to code than temp table + update using pass through?</p>