Date:         Wed, 24 Oct 2007 23:10:26 +0530
Reply-To:     Anindya Mozumdar <anindya.lugbang@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Anindya Mozumdar <anindya.lugbang@GMAIL.COM>
Subject:      Re: Export to Excel w/o Variable Names in First Row
Comments: To: Paul Walker <walker.627@osu.edu>
In-Reply-To:  <200710241424.l9OAkWo9026286@mailgw.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

After going through the documentation in the Base SAS procedures
guide, I don't think there is a way to do this using proc export.

On 10/24/07, 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
>