10-02-2015 09:35 AM
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.
10-02-2015 09:55 AM
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;