Date:         Fri, 27 Jun 2008 16:30:03 -0500
Reply-To:     "data _null_," <datanull@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "data _null_," <datanull@GMAIL.COM>
Subject:      Re: Column names across multiple rows in excel/html
Comments: To: parantap.chatterjee@gmail.com
In-Reply-To:  <bf31dd19-af8d-4016-9191-1c081358aa31@s33g2000pri.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

Do they appear to "span" columns or do they actually span columns.  I
suspect the former.  If you click on the cell what shows up in the
"fx" box.

On 6/27/08, parantap.chatterjee@gmail.com <parantap.chatterjee@gmail.com> wrote:
> i have variables in my dataset with names like "var_1" "var_2" etc and
> each of them have longish labels..around 40-50 characters. i am using
> PROC Print to print the dataset and im using ods to get the output in
> excel via ods html (since PROC Export doesn't export labels). now when
> i open the excel file some of the column headings (variable labels in
> the SAS dataset) appear across multiple rows in the excel instead of
> in a single cell e.g. if the heading for column A is ABCDEFGHIJKLMNOP
> then i have ABCD in cell A1 , EFGHIJK in cell A2 and LMNOP in A3.. is
> there any way of avoiding this and have the entire label/heading in
> A1 ?
>