topic Re: Writing SAS data into MS Excel without varnames in SAS Programming

Writing SAS data into MS Excel without varnames

deleted_user — Tue, 22 Jul 2008 13:08:25 GMT

Hi,
I am trying to use the LIBNAME statement to read and write the data from/into the excel file. To access I use also the named ranges as mentioned in http://www2.sas.com/proceedings/sugi31/024-31.pdf

I have the the following question:
is there any possibility to write the SAS data into MS Excel named range without writing the variable names? (I have found the libname option HEADER=NO that for reading without varnames, but this doesn't work when writing into excel).

My SAS version is 9.1.3.

Thank you in advance!
Jaroslav

Re: Writing SAS data into MS Excel without varnames

jc671 — Fri, 04 Jun 2010 17:49:57 GMT

Any luck finding the answer to this question? I tried using options HEADER=NO and dbSasLabel=none but they did not work.

Thank You,
JC

Re: Writing SAS data into MS Excel without varnames

Ksharp — Sat, 05 Jun 2010 10:55:48 GMT

There are some suggestion from Cynthia@sas .

[pre]
data _null_;
set sashelp.class;
file 'c:\range.csv' dsd;
put name sex;
run;
[/pre]

then open range.csv by excel and Save As ----> xls file.

Ksharp

Re: Writing SAS data into MS Excel without varnames

sbb — Sat, 05 Jun 2010 12:14:42 GMT

Starting with SAS 9.2, ODS CSV can optionally suppress a column header row. Check the options DOC.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic/post:

+"ods csv" +options +doc site:sas.com

Re: Writing SAS data into MS Excel without varnames

Ksharp — Sun, 06 Jun 2010 03:50:51 GMT

Thx. I am using older SAS.

Re: Writing SAS data into MS Excel without varnames

Peter_C — Sun, 06 Jun 2010 11:11:33 GMT

Jaroslav
Which version do you use?

If you want to write into an existing range name (in an existing excel workbook), you have very few methods where the range does not have a header row.
It is possible that the only way will be the (much-deprecated) DDE which has worked in all releases of SAS on windows since SAS version 6.08. It needs to be able to write into an open instance of excel.
Which versions of excel and sas do you use?

peter

Re: Writing SAS data into MS Excel without varnames

Ksharp — Mon, 07 Jun 2010 05:24:25 GMT

Thank u. I will check it out.