The SAS Output Delivery System and reporting techniques

tagsets.ExcelXP align and wrap

Reply
N/A
Posts: 0

tagsets.ExcelXP align and wrap

Hi,

I'm creating an Excel sheet using the ODS tagsets.ExcelXP.

But two things just won't work....

First the alignment of cells. Example:
[PRE]
PROC REPORT DATA=sashelp.class ;
COLUMN _ALL_ ;
DEFINE sex /STYLE(COLUMN)=[just=center] ;
RUN ;
[/PRE]
The style element "just=center" does nothing in the Excel sheet.

Second the wrapping of cells. It's standard with the column headers but not within a table.

Can anyone help me with this?

Thnx,
Thierry
SAS Employee
Posts: 95

Re: tagsets.ExcelXP align and wrap

Which version of the Excelxp tagset are you using?

It should say in the log. If it doesn't say, then it is very old.

You can get the latest tagset here.

http://support.sas.com/rnd/base/ods/odsmarkup/
SAS Super FREQ
Posts: 8,743

Re: tagsets.ExcelXP align and wrap

Hi:
When I run this code:
[pre]
ods tagsets.excelxp file='c:\temp\try_cntr.xls'
style=sasweb
options(absolute_column_width="20,15,15" doc="Help");

proc report data=sashelp.class nowd
style(column)={just=center};
column name age height;
run;

ods tagsets.excelxp close;

[/pre]

I do see centering (in Excel 2007). Sometimes, you have to make the columns "bigger" in order to see the impact of centering.
I am running the version of the ExcelXP tagset template dated:
[pre]
NOTE: This is the Excel XP tagset (SAS 9.1.3, v1.75, 07/26/07). Add options
(doc='help') to the ods statement for more information.

[/pre]

(from my SAS log)
cynthia
N/A
Posts: 0

Re: tagsets.ExcelXP align and wrap

Hi,

Thanks for your reply.

When I run Cynthia's code the centering doesn't work.
I guess it's because the old version of the tagsets I'm using.

I'm using the version:
[pre]
NOTE: This is the Excel XP tagset (SAS 9.1.3, v1.28, 08/29/05). Add options(doc='help') to the ods statement for more information.
[/pre]
I'll update the Tagset and try again.

The wrapping of cells? Is there an option for?

Thanks!
Thierry Message was edited by: TH
Ask a Question
Discussion stats
  • 3 replies
  • 1330 views
  • 0 likes
  • 3 in conversation