Updating the excel file and keeping the old tabs

jhh197 — Tue, 02 Aug 2016 18:40:00 GMT

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;

Re: Updating the excel file and keeping the old tabs

GaneshLekurwale — Wed, 03 Aug 2016 02:02:41 GMT

Try changing dbms statement as : dbms= xlsx REPLACE ;

Re: Updating the excel file and keeping the old tabs

LinusH — Wed, 03 Aug 2016 06:50:22 GMT

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

topic Updating the excel file and keeping the old tabs in SAS Procedures

Updating the excel file and keeping the old tabs

Re: Updating the excel file and keeping the old tabs

Re: Updating the excel file and keeping the old tabs