Date:         Fri, 2 Oct 2009 13:27:43 -0700
Reply-To:     Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: ODS tagsets.excelxp: Is it possible not to display column
              names  and to switch off text wrapping for all cells of a column?
Comments: To: "Data _null_;" <iebupdte@GMAIL.COM>
In-Reply-To:  <ce1fb7450910021310y1b7995b9p27c73593b7ada0e0@mail.gmail.com>
Content-Type: text/plain; charset=iso-8859-1; format=flowed; delsp=yes

I don't like using '00'x because (as far as I know) it's not
guaranteed to continue to work.  And doesn't using splitchar add an
extra row?  I haven't tried it recently.

--
Jack Hamilton
jfh@alumni.stanford.org
Tots units fem força!




On Oct 2, 2009, at 1:10 pm, Data _null_; wrote:

> On 10/2/09, Jack Hamilton <jfh@stanfordalumni.org> wrote:
>> It varies by PROC.  I haven't found a way I like with PROC PRINT.
>
> Are you referring to the blank row that is produce when you use
> label='00'x or label='splitchar'.
>
> ods tagsets.excelxp file='print.xls';
> proc print data=sashelp.class label noobs;
>   attrib _all_ label= '00'x;
>   run;
> ods tagsets.excelxp close;
>
> This code is nice and concise but we still have that blank line.
>
> PROC REPORT can be concise as well, and no blank row.
>
> ods tagsets.excelxp file='report.xls';
> proc report data=sashelp.class nowd list;
>   define _all_ / display ' ';
>   run;
> ods tagsets.excelxp close;
>
>