stop multisheet excel export

[arunmmw]

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;

[RW9 · Accepted solution]

Hi,

options (sheet_interval=none).

Options for the tagset are here: Base SAS: Quick Reference for TAGSETS.EXCELXP Tagset

[arunmmw]

Thanks for the tagsets link