Sheet names in ODS TAGSETS.EXCELXP

[SuryaKiran]

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;

[Reeza · Accepted solution]

Change MAKE into a By variable instead. 

Then there are options within tag sets.