DATA Step, Macro, Functions and more

Output text file with header record

Reply
Learner
Posts: 1

Output text file with header record

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.

Super User
Super User
Posts: 7,950

Re: Output text file with header record

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;
Trusted Advisor
Posts: 1,913

Re: Output text file with header record

[ Edited ]

PROC EXPORT with DBMS=TAB will do what you want

Ask a Question
Discussion stats
  • 2 replies
  • 228 views
  • 0 likes
  • 3 in conversation