Hi SAS Experts, I am using ods excelxp to output xml files and to wrap the text columns, and am able to do that. But by default ods excelxp is opening the xml files after exporting them, here I want to stop this default behaviour of ods excelxp, is there is any options to do this. Actually there more than 100 files am creating using excelxp concept and it witll be difficult for me to close them each time. Here is my code. data a; set sashelp.class; run; data a; set a; amount=age*weight; run; proc sql; select count(distinct sex) into : c from a; quit; proc sql; select distinct sex into:sex1-:sex%sysfunc(compress(&c)) from a; quit; %macro b; %do i=1 %to &c; ods tagsets.excelxp file="path\a_&&sex&i...xml" style=statistical options(absolute_column_width='10,5,5,5,5'); proc print data=a noobs; var name sex age weight height; var amount/style(data)={tagattr='format:"$"#,##0'}; where sex="&&sex&i."; run; ods tagsets.excelxp close; %end; %mend b; %b; Thanks & regards, Sanjay.
... View more