Updating the excel file and keeping the old tabs

[jhh197]

Hi ,

I have to create one excel   Femalelist._1 TABS A and B come after running macro  sales2 and TABS C and D come after running macro  sales3  BUT Femalelist._1  finally should have A,B,C,D tabs  in this locatio c:\myfiles but i ahve two files Femalelist._1 xlsx.xlsx

Femalelist._1.xlsx.xlsx but i want only one Femalelist._1 with all A,B,C, and D tabs

i am writing two proc export for macro1 and macro2

%macro sales2;

proc sql;

create table xy_&p. as

  select * from abb

where item_nm = "&desc."

proc export
data= xy_&p.
outfile= "c:\myfiles\Femalelist._&id.xlsx"
dbms= xlsx ;
SHEET="&desc";
run;

%mend ;

%sales2;

%macro sales3;

proc sql;

create table yg_&pq. as

  select * from ccd

where ins_nm = "&name_des."

proc export
data= yg_&pq.
outfile= "c:\myfiles\Femalelist._&id.xlsx"
dbms= xlsx ;
SHEET= "&name_des."
run;

%mend ;

%sales3;

[GaneshLekurwale]

Try changing dbms statement as :    dbms= xlsx REPLACE ; 

[LinusH]

Perhaps you could get it to work with proc export.
But spontaneously i would try the Excel libname engine for this scenario.