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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.