topic Proc export to update an existing excel sheet? in SAS Programming

Proc export to update an existing excel sheet?

liquidimports — Tue, 19 Apr 2016 18:53:31 GMT

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;

Re: Proc export to update an existing excel sheet?

SASKiwi — Tue, 19 Apr 2016 19:34:36 GMT

Does adding the REPLACE option help?

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

Re: Proc export to update an existing excel sheet?

liquidimports — Wed, 20 Apr 2016 11:40:40 GMT

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

Re: Proc export to update an existing excel sheet?

liquidimports — Mon, 25 Apr 2016 13:12:45 GMT

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