Sheet names in ODS TAGSETS.EXCELXP

SuryaKiran — Wed, 09 Nov 2016 18:45:22 GMT

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;

Re: Sheet names in ODS TAGSETS.EXCELXP

Reeza — Wed, 09 Nov 2016 18:56:49 GMT

Change MAKE into a By variable instead.

Then there are options within tag sets.