CSV = Comma Separated Variable text file. Is designed for data transfer. It is not an Excel file!
Now decide what you want that output for, if it is to send data somewhere, then go ahead and export to CSV, and all the data will appear, ID on each line per the definition of a CSV. If however you just want some review output in Excel, then use proc report and create a report in an Excel file - ods tagsets.excelxp or excel will do the trick and you have all the functionality therein.
Again, CSV is not the same as Excel.
... View more