Prev: Read Access Violation error
Next: SAS programming practice
From: "Curtis E. Reid" on 22 Jul 2008 14:54
As a follow-up to my own post:

I wonder if this is because it does not work well with PROC PRINT which is
what the original data was based on. PROC REPORT would appear to be a
better option. I'm still not getting borders, though, in PROC REPORT with
BOX option. Thanks.
From: BruceK on 23 Jul 2008 15:59
Curtis,

Did you try options(autofit_height='yes') to wrap the text within the
cells. You may also have to use
this in combination with setting the default_column_width option to
prevent the columns from expanding to the full width of the data.

For gridlines I use a modified style, see a previous post, search for
"Question of Style Attribute: bordercolor " in this group

Bruce Kayton


On Jul 22, 9:53 am, reid.cur...(a)BLS.GOV ("Curtis E. Reid") wrote:
> I'm using SAS v9.1.3 SP4 with TAGSETS.EXCELXP downloaded from SAS Institute
> version 1.86 04/15/08.
>
> I am trying to create text wrap within a cell using TAGSETS.EXCELXP but I
> cannot get it to work properly.  According to XML, the text is ss:WrapText="1".
>
> Also, I had OPTIONS(GRIDLINES = 'YES') but I am not seeing any gridlines
> when viewing it.  I want all cells gridded.  What about FRAME = BOX that
> didn't work either?
>
> I must be misunderstanding the documentation in either EXCELXP or SAS v9 doc.
>
> I tried to search this site first but I'm not getting good hits.  If there
> are posts already on this topic, kindly please re-direct me to these.  :)
>
>    --Curtis E. Reid
>
> PS. Please email me a copy of your post.

 | 
Pages: 1
Prev: Read Access Violation error
Next: SAS programming practice