02-14-2014 01:42 PM
I need to export from SAS to Excel.
I tried with the proc export but it changed the format and it did not show the column names.
How can I export?
02-15-2014 10:42 AM
Insert "label" into the code before replace, this will export the labelled column names from SAS into excel. Mind you if you put labels onto the columns in SAS ie rather than UID you have the label "Unique ID variable", "Unique ID variable" is what will appear in Excel.
If you have variable labels and wanted the SAS variable name to actually be output you could put this before your proc export statement
proc datasets lib=work memtype=data;
attrib _all_ label=' ';
Hope this helps.