DATA Step, Macro, Functions and more

Sheet names in ODS TAGSETS.EXCELXP

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 118
Accepted Solution

Sheet names in ODS TAGSETS.EXCELXP

Hi Experts!

 

I want the sheet name to be the page in PROC TABULATE. For my  example I need sheet names like Acura, Audi,............

 

 

ODS listing close;

ODS tagsets.ExcelXP

file='/home/suryakiran/excel_output/cars.xml'

STYLE=HTMLBlue

Options(embedded_titles = 'yes');

PROC TABULATE

DATA=SASHELP.CARS;

CLASS Type Model Make;

TABLE /*Page*/ Make,

/*Row */ Model ALL={LABEL="Total"},

/*Colm*/ Type*N N ;

RUN;

ODS tagsets.ExcelXP close;


Accepted Solutions
Solution
‎11-09-2016 03:51 PM
Super User
Posts: 17,801

Re: Sheet names in ODS TAGSETS.EXCELXP

Change MAKE into a By variable instead. 

Then there are options within tag sets. 

View solution in original post


All Replies
Solution
‎11-09-2016 03:51 PM
Super User
Posts: 17,801

Re: Sheet names in ODS TAGSETS.EXCELXP

Change MAKE into a By variable instead. 

Then there are options within tag sets. 

☑ This topic is SOLVED.

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

Discussion stats
  • 1 reply
  • 184 views
  • 1 like
  • 2 in conversation