Date:         Wed, 24 Oct 2007 13:43:38 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Export to Excel w/o Variable Names in First Row
Comments: To: Paul Walker <walker.627@OSU.EDU>

Paul,

In spite of the facts that I'm still on vacation and how your school
mistreated my school last weekend (congratulations on the ranking by the
way), I'll offer a possible solution.

Would something as simple as the following suffice?

data test;
  input a @6 b $20. @26 c;
  cards;
123  some test data      56
14   some more test data 80
4522 yet more test data  947
;

data _null_;
 set  test;
 file "c:\csvtest.csv" lrecl=32000 dsd ;
 put (_all_)(:) ;
run;

Art
--------
On Wed, 24 Oct 2007 10:24:00 -0400, Paul Walker <walker.627@OSU.EDU> wrote:

>I am using proc export to send a SAS dataset to excel.  However, the first
>row of the spreadsheet contains the SAS variable names.  I do not want the
>SAS variable names to be output to the spreadsheet.  How can I do this?
>
>My export code (taken from a macro) is shown below:
>
>  /* Export an excel 2000 Worksheet */
>  proc export outfile = "&_ExcelFile"
>              data    = &_Work..&smn._7
>              dbms    = excel2000
>              replace
>             ;
>    sheet="&_Sheet";
>  run;
>
>TIA,
>Paul