Right justification of column headings in Proc Report using ExcelXP tagset

[deleted_user]

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?

[Cynthia_sas]

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

[deleted_user]

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

[deleted_user]

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

[Cynthia_sas]

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

[deleted_user]

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.