DATA Step, Macro, Functions and more

how to get column label name on export to excel

Reply
Contributor
Posts: 67

how to get column label name on export to excel

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.

Super User
Posts: 23,296

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

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.


 

Super User
Posts: 10,689

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

Import excel:

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

 

Export excel:

proc export data=sashelp.class outfile='c:\temp\class.xls' dbms=excel replace ;
label;
run;
Ask a Question
Discussion stats
  • 2 replies
  • 88 views
  • 0 likes
  • 3 in conversation