topic Re: Output text file with header record in SAS Programming

Output text file with header record

EYend — Fri, 02 Oct 2015 13:35:16 GMT

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.

Re: Output text file with header record

RW9 — Fri, 02 Oct 2015 13:55:08 GMT

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;

Re: Output text file with header record

PaigeMiller — Fri, 02 Oct 2015 14:01:12 GMT

PROC EXPORT with DBMS=TAB will do what you want