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,866

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

Posted in reply to deleted_user
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

Posted in reply to Cynthia_sas
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

Posted in reply to Cynthia_sas
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,866

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

Posted in reply to deleted_user
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

Posted in reply to Cynthia_sas
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
  • 187 views
  • 0 likes
  • 2 in conversation