topic Re: excelxp title width defining in SAS Programming

excelxp title width defining

dgm1012 — Sat, 21 Feb 2015 19:27:24 GMT

I am creating a multi sheet report using 4 macros and proc tabulate. each time a macro is called, i define my options, for example

ods tagsets.excelxp options

(

center_horizontal = 'yes'

center_vertical = 'yes'

embedded_titles='yes'

embedded_footnotes='yes'

merge_titles_footnotes = 'yes'

sheet_name= &sheet

width_points='1'

width_fudge='1'

absolute_column_width = '80,125,50,50,50,50,50,30,30,30,30,30,30,30,30,30'

row_heights = '50,17,20,15,12,10'

);

title1 justify=center bold color=grey font=arial height=10pt &title1;

title2 justify=center bold color=grey font=arial height=10pt &title2;

title3 justify=center bold color=grey font=arial height=10pt &title3;

footnote justify=left bold color=grey font=arial height=8pt &source;

this creates my first sheet, summary. it goes to column F.

every sheet after that has the titles and footnotes also set to only go to column F, not however wide that particular table is. Is there a way to have the titles and footnotes be defined for the particular table on the sheet, not just whatever the first sheets width was?

Re: excelxp title width defining

Cynthia_sas — Sun, 22 Feb 2015 00:55:05 GMT

Hi:

This is really a question for Tech Support. Normally, titles and footnotes go in the header/footer of the sheet, where they are bound to margins and orientation of the printed sheet. When you embed the titles and footnotes, they have to be tied to something, so making them fit the width of the table seems to be the decision. But to get hellp to figure out whether you can change the behavior is really a question for Tech Support.

cynthia

Re: excelxp title width defining

Vish33 — Sun, 22 Feb 2015 13:44:00 GMT

when you define next macro , clear titles and footnotes an then give titles an footnotes.

title;

footnote;

title1 "...........";

footnote1 "............";

i didnt test it....

Re: excelxp title width defining

dgm1012 — Sun, 22 Feb 2015 15:57:38 GMT

Tried this but did make a difference, thank you for the idea though.

Re: excelxp title width defining

dgm1012 — Sun, 22 Feb 2015 16:18:01 GMT

To make this potentially even more confusing, when results are output to browser (firefox in this instance), the alignment is as coded, only in excel is one particular title aligned left.

Re: excelxp title width defining

dgm1012 — Sun, 22 Feb 2015 17:57:19 GMT

After updating to newest tagsets this was not an issue anymore.