topic Re: how to get column label name on export to excel in SAS Programming

how to get column label name on export to excel

radha009 — Wed, 21 Mar 2018 16:11:56 GMT

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.

Re: how to get column label name on export to excel

Reeza — Wed, 21 Mar 2018 16:23:08 GMT

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.

Re: how to get column label name on export to excel

Ksharp — Thu, 22 Mar 2018 13:43:17 GMT

Import excel:

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

Export excel:

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