The SAS Output Delivery System and reporting techniques

Right justification of column headings in Proc Report using ExcelXP tagset

Reply
N/A
Posts: 0

Right justification of column headings in Proc Report using ExcelXP tagset

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?
SAS Super FREQ
Posts: 8,744

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

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
N/A
Posts: 0

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

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
N/A
Posts: 0

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

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
SAS Super FREQ
Posts: 8,744

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

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
N/A
Posts: 0

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

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.
Ask a Question
Discussion stats
  • 5 replies
  • 186 views
  • 0 likes
  • 2 in conversation