I recently began work with a new company that uses Enterprise Guide which my previous employer did not have for me to test on. I have several macros that output tables specifically formatted to look the same in all destinations (RTF, Excel, PDF, HTML, etc.), but the results viewer in Enterprise Guide isn't following the style modifications like the other destinations. EG is using ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR as the destination. Here is some example code:
ods rtf file='test.rtf';
ods escapechar='^';
proc report data=sashelp.class nowd split='~' style(header)={vjust=bottom};
columns name sex age height weight;
define name / display 'Name^{super 1}' style={cellwidth=1.5in};
define sex / display 'Test~Sex';
compute sex ;
if sex='F' then call define('name','style/merge','style={fontweight=bold}');
else call define('name','style/merge','style={leftmargin=0.12in}');
endcomp;
compute after;
line @1 '^{super 1}This Is A Test Footnote';
endcomp;
run;
ods rtf close;
When I look at the RTF file I get the following:
However when I look at the same table output in the EG results window I get the following:
I can't seem to fix the following issues:
I can't get text to indent. I have tried using the INDENT style element as well as the LEFTMARGIN style element and both are ignored
When using the escape character to superscript a text it seems to delete all of the spaces in the rest of the text and ignores things like vertical justification (see footnote and first column header vs the rest)
When I try changing to a new style with ODS tagsets.sasreport13(ID=EGSR) style=SomeNewStyle; it ignores the new style unless I close the tagsets and start a new one with the style I want. Is there a way to make it change to the style that I want without closing/reopening the destination?
I don't think the company focuses too much on what the results look like in the EG results window, but I'm just curious about figuring out what is going on.
... View more