topic Re: Applying superscript to a variable instead of text in ODS and Base Reporting

Applying superscript to a variable instead of text

jmck — Mon, 10 Jan 2022 22:45:00 GMT

I am working in Proc Report with escape character="^". I am trying to apply superscript formatting to a variable and not to specific harcoded text.

For example:

I have 2 columns of data: Product and ProductCit

I would like to have 1 column where Product is the base and ProductCit is the superscript.

I've tried doing it in a compute block but can't find syntax that will take a variable name:

compute Product / character length=250 ;

Product=cat(Product,ProductCit) ;
endcomp ;

I've also tried adding it as a format to ProductCit in the define statement:

define ProductCit / display style(column)= [] ;

I can only seem to find examples where the superscript text is hard coded. Unfortunately, mine will be dynamic and I need to apply the format to the variable. Does anyone know how or have any ideas? I've been reading papers for days!

Re: Applying superscript to a variable instead of text

Reeza — Mon, 10 Jan 2022 23:51:39 GMT

Pretty sure you need to add the escape character to the variable value as well and/or add some style elements to get it properly displayed.

It also likely matters what your final output destination is, RTF, HTML PDF, WORD, PPTX?

Re: Applying superscript to a variable instead of text

Reeza — Mon, 10 Jan 2022 23:55:13 GMT

FYI - I've moved this post to the reporting forum instead of general programming.

Re: Applying superscript to a variable instead of text

jmck — Mon, 10 Jan 2022 23:58:44 GMT

Outputting to Excel. .xlsx
Worst case, I had an idea to use macro variables to output the text, but that'll be my last resort before throwing in the towel.

Re: Applying superscript to a variable instead of text

Reeza — Tue, 11 Jan 2022 00:10:30 GMT

Can you post some fake data with current code to play around with?

Re: Applying superscript to a variable instead of text

Ksharp — Tue, 11 Jan 2022 11:44:22 GMT

data have;
set sashelp.class;
super=cat(name,'(*ESC*){super ',age,'}');
run;


ods excel file='c:\temp\temp.xlsx';
proc report data=have nowd;
column name age super;
define name/display;
run;
ods excel close;

Re: Applying superscript to a variable instead of text

jmck — Tue, 11 Jan 2022 13:53:15 GMT

Thanks so much! I'll try it as soon as I get on today.

Re: Applying superscript to a variable instead of text

jmck — Tue, 11 Jan 2022 15:38:20 GMT

A thousand THANKS!

Re: Applying superscript to a variable instead of text

DrAbhijeetSafai — Thu, 25 Apr 2024 04:41:16 GMT

Wonderful @Ksharp ! Thank you!

- Dr. Abhijeet Safai