stop multisheet excel export

arunmmw — Mon, 16 Mar 2015 16:37:12 GMT

Hi,

I am trying to create an excel report that breaks down the records by Name.

E.g.

Name ABC:

Result set 1

Name DEF"

Result set 2:

This code gets me the result set by Name but exports to a multi sheet .xls file. Is there anyway I can put it all into one excel file.

ods listing close;

ods tagsets.ExcelXP BODY ='test.xls'

style=Printer;

proc sort data=testFinal; by Name; run;

proc report data=testFinal nowd STYLE(REPORT)={Rules=none }

style(header) = {background=#99CCFF font_face=Arial};

BY Name;

column START_DATE numberofcall numberofpeople sucessrate Name;

DEFINE Team_Code_1 / ORDER 'Type' MISSING;

BREAK AFTER Name/ summarize;

quit;

ods tagsets.ExcelXP close;

Re: stop multisheet excel export

RW9 — Mon, 16 Mar 2015 16:46:00 GMT

Hi,

options (sheet_interval=none).

arunmmw — Mon, 16 Mar 2015 16:54:15 GMT

Thanks for the tagsets link