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;
Try changing dbms statement as : dbms= xlsx REPLACE ;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.