Hello everybody

is it possible to export a file with SAS but without the variable
names appear in the first line?

Thanks in advance

yes

On Mar 15, 7:42=A0am, Patrick <patrick.mat...@gmx.ch> wrote:
> yes

If you can live with a blank row at the top of the sheet where the
names were, this should work for you.

There are other solutions, ie DDE

The following wil remove the variable names but will not delete the
variable names row. I don't think MS Jet/Ace-ODBC supports deleting/
inserting rows in Excel.


What is going on below.

I create a 'table'(named range class) in excel with sashelp.class.
I drop the table.
I still have the empty  table object in excel so I modify the table
using the excel column names.

libname xls "c:\nonhed.xls" scan_text=3Dno;
data xls.class;
 set sashelp.class ;
run;
proc sql;
 drop table xls.class;
run;
data XLS.'class$'n ;
 modify XLS.'class$'n;
 set sashelp.class(keep=3Dname sex rename=3D(
    name=3Df1
    sex=3Df2
    ));
run;
libname xls clear;

On Mar 15, 8:37=A0am, bechbech <bechir.maghr...@gmail.com> wrote:
> Hello everybody
>
> is it possible to export a file with SAS but without the variable
> names appear in the first line?
>
> Thanks in advance

Try this:

data _null_;
  set sashelp.class;
  file 'class.csv' dsd lrecl=3D30000;
  put (_all_) (:);
run;