Output text file with header record

[EYend]

I would like to know how to output a tab delimited text file with the first header record being the field names.

I used if _n_=1 to insert header record but it did not work.

[RW9]

Hi,

Something like (note that I would recommend comma separated, tabs are too application specific):

proc sql noprint;
  select distinct NAME 
  into  :VLIST separated by " "
  from  SASHELP.VCOLUMN
  where LIBNAME="SASHELP"
    and MEMNAME="CARS";
quit;

data _null_;
  set sashelp.cars;
  file "s:\temp\rob\temp.txt" dlm=",";
  if _n_=1 then do;
    temp=tranwrd("&vlist."," ",",");
    put temp;
    put &vlist.;
  end;
  else put &vlist.;
run;

[PaigeMiller]

PROC EXPORT with DBMS=TAB will do what you want