how to get column label name on export to excel

[radha009]

How to display the column label names on export to excel sheet.

i have columns names in the script as orders,type,quantity etc. in main excel import i have orders ticket4343,type ticket32424,quantity placed tkt4324. how do i export the exact names from main excel.

[Reeza]

How are you exporting your data?

---

@radha009 wrote:

How to display the column label names on export to excel sheet.

i have columns names in the script as orders,type,quantity etc. in main excel import i have orders ticket4343,type ticket32424,quantity placed tkt4324. how do i export the exact names from main excel.

---

[Ksharp]

Import excel:

option validvarname=any;
proc import ..........

Export excel:

proc export data=sashelp.class outfile='c:\temp\class.xls' dbms=excel replace ;
label;
run;