Help using Base SAS procedures

Updating the excel file and keeping the old tabs

Reply
Contributor
Posts: 37

Updating the excel file and keeping the old tabs

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;

 

New Contributor
Posts: 3

Re: Updating the excel file and keeping the old tabs

Try changing dbms statement as :    dbms= xlsx REPLACE ; 

Super User
Posts: 5,429

Re: Updating the excel file and keeping the old tabs

Perhaps you could get it to work with proc export.
But spontaneously i would try the Excel libname engine for this scenario.
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 256 views
  • 0 likes
  • 3 in conversation