title: Proc export to update an existing excel sheet in SAS?
body: <p>I am trying to update (keep adding rows) an existing excel file (if it is somehow possible) but the data keeps replacing or overwriting. I want the Claims tab to keep updating when the sas is ran. Adding "REPLACE" would overwrite the data as well. Any suggestions would be appreciated.</p>
  
  <pre><code>proc export
  data=hdat.revclaimsmaster 
  outfile="\TEST.xlsx"
  dbms=excel;
  SHEET="Claims";
  run;
  
  proc export
  data=hdat.nonrevclaimsmaster  
  outfile="\TEST.xlsx"
  dbms=excel;
  SHEET="Claims";
  run;
  </code></pre>