Help using Base SAS procedures

stop multisheet excel export

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

stop multisheet excel export

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;


Accepted Solutions
Solution
‎03-16-2015 12:46 PM
Super User
Super User
Posts: 7,565

Re: stop multisheet excel export

Hi,

options (sheet_interval=none).

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

View solution in original post


All Replies
Solution
‎03-16-2015 12:46 PM
Super User
Super User
Posts: 7,565

Re: stop multisheet excel export

Hi,

options (sheet_interval=none).

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

Occasional Contributor
Posts: 17

Re: stop multisheet excel export

Thanks for the tagsets link

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 190 views
  • 0 likes
  • 2 in conversation