SAS places the variables names in Row 1 when you try to create an excel or .CSV file of the SAS dataset. I have found a tip to tell SAS not to keep variable names in the row 1 of .CSV file.SAScommunity.org page has put together nice information regarding how to do this.
1 Run Proc Export with PUTNAMES=NO2 Run PROC EXPORT and recall and edit the code3 Run PROC EXPORT and use a DATA step to rewrite the file without the first row4 DATA _NULL_ with a PUT statement5 DATA _NULL_ with a PUT statement, all fields quoted6 ODS CSV and PROC REPORT with suppressed column headers7 The %ds2csv SAS Institute utility macro8 The CSV tagset and the table_headers="NO" option Run PROC EXPORT with PUTNAMES=NO Sample program
proc export data=data_to_export outfile='C:\data_exported.csv' dbms=csv ...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]