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.
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;
PROC EXPORT with DBMS=TAB will do what you want
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.