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
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?
input a @6 b $20. @26 c;
123 some test data 56
14 some more test data 80
4522 yet more test data 947
file "c:\csvtest.csv" lrecl=32000 dsd ;
put (_all_)(:) ;
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