topic Re: Is it possible to get superscripts in ODS EXCEL output? in ODS and Base Reporting

Is it possible to get superscripts in ODS EXCEL output?

ABritinAus — Wed, 26 Oct 2016 22:05:59 GMT

Does anyone know how to get superscripts coming out in XLSX files produced using ODS EXCEL?

They come out fine using ODS tagsets.excelxp (but we'd like to move to ODS EXCEL as it does certain other things better)

I run the following code (using SAS 9.4 maintenance release 3):

ods escapechar='^';

ods excel file='c:\temp\test.xlsx'

options(sheet_name="test" embedded_titles="yes" embedded_footnotes="yes" TITLE_FOOTNOTE_NOBREAK="yes");

proc tabulate data=sashelp.class;

var height weight;

class age sex;

table age=' ',

mean=' '*sex='Gender Average ^{super(a)}'*(height weight)

mean='Overall Avg'*(height weight) /

box={label='Age'};

run;

ods excel close;

The requested superscripted (a) appears as such in the results (sasreport) window.

But in the XLSX file, the (a) doesn't appear at all, with or without superscript.

Re: Is it possible to get superscripts in ODS EXCEL output?

Ksharp — Thu, 27 Oct 2016 02:37:07 GMT

Could you use

'Gender Average ^{unicode 23456 }'

find the right number by yourself . Google or check Word's symbol table.

Re: Is it possible to get superscripts in ODS EXCEL output?

ABritinAus — Thu, 27 Oct 2016 02:53:04 GMT

Thanks for the suggestion.

Unicodes DO seem to work in ODS Excel output.

But from what I can see there is a unicode for subscripted a

but not for superscripted a.

We need to be able to superscript other letters (not just those with unicodes), and for them to be in parentheses.

The unicode parentheses look a bit weird (especially when bold) and probably wouldn't satisfy our publications team, who are used to the "usual" looking superscripting that we can get in ODS tagsets.EXCELXP.

Hopefully there is an easier way.

But thanks again for the response.

Re: Is it possible to get superscripts in ODS EXCEL output?

Tim_SAS — Thu, 27 Oct 2016 13:23:56 GMT

Add a blank between super and (a)

mean=' '*sex='Gender Average ^{super (a)}'*(height weight)

I've reported the problem to Tech Support.

Re: Is it possible to get superscripts in ODS EXCEL output?

ABritinAus — Sun, 30 Oct 2016 21:58:46 GMT

Ah, I should have tried adding a blank in myself.

Thanks Tim.

Much appreciated.