Proc export to update an existing excel sheet?

[liquidimports]

Hi,

Im reaching out to this community for help with a small issue. I am trying to update 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.  Any suggestions would be appreciated.

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;

[SASKiwi]

Does adding the REPLACE option help?

proc export
data=hdat.nonrevclaimsmaster  
outfile="\TEST.xlsx"
dbms=excel
replace;
SHEET="Claims";
run;

[liquidimports]

Hi, Thank you for the reply.
Replace does not help. It just overwrites.

[liquidimports · Accepted solution]

I was able to bypass it by adding &RUNDT to the filename. It creates an excel file with a current date in a title