topic Re: Right justification of column headings in Proc Report using ExcelXP tagset in ODS and Base Reporting

Right justification of column headings in Proc Report using ExcelXP tagset

deleted_user — Mon, 14 May 2007 21:18:45 GMT

In my Proc call, I've specified a right justification....but it does not appear that it is being applied in my output. Everything is still left justified. Is this a functionality that is not currently working in the tagset?

proc report data = prodsum2T nowd missing
style(header)={font_weight=bold font_size=3 just=right};
......code
run;

Both the bold and sizing is getting applied correctly. Any thoughts?

Re: Right justification of column headings in Proc Report using ExcelXP tagset

Cynthia_sas — Mon, 14 May 2007 21:50:09 GMT

I just downloaded the March 07 tagset for ExcelXP, submitted the code. Then I tested with PROC REPORT and got right-justified Headers when I ran my test.
cynthia

Re: Right justification of column headings in Proc Report using ExcelXP tagset

deleted_user — Tue, 15 May 2007 13:34:30 GMT

I'm using an older version of the tagset....perhaps that's what the problem is.

I'll give the new one a try!

Thanks Cynthia.

Darryl

Re: Right justification of column headings in Proc Report using ExcelXP tagset

deleted_user — Tue, 15 May 2007 15:54:58 GMT

Hi Cynthia...

Running the updated tagset, I still do not get right-justified headers. I presume my next step should be to contact tech support?

Thanks,
Darryl

Re: Right justification of column headings in Proc Report using ExcelXP tagset

Cynthia_sas — Tue, 15 May 2007 17:15:55 GMT

I downloaded JUST the ExcelXP tagset that was marked NEW March 2007 -- if that's the one that you downloaded and tested, then, yes, your best bet is to contact Tech Support.
(BTW, I had to manually drag the Excel columns wider to see the effect.)
Good luck,
cynthia

Re: Right justification of column headings in Proc Report using ExcelXP tagset

deleted_user — Tue, 22 May 2007 20:44:14 GMT

Apparently the problem had to do with trying to set multiple options in the proc report call. By moving the bold and justification to a proc template, everything works now.