Solved: Sent to excel - column heading

JSJ · Posted 05-19-2016 04:22 PM

Hi,

Reset my naming options to use labels from column names. (Tools>Options>Data>Data General, Use Labels for column names.)

This works great!

But now when I "send to" excel, the headers are not the labels.

Works ok with the export option, though. I would prefer to use "Send to". Any ideas?

Thanks!

ChrisHemedinger · Posted 05-19-2016 04:41 PM

How about using Copy with Headers (version 7.1 and later)? That feature will use the labels when you have the option enabled.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

ChrisHemedinger · Posted 05-19-2016 04:41 PM

How about using Copy with Headers (version 7.1 and later)? That feature will use the labels when you have the option enabled.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

JSJ · Posted 05-19-2016 05:03 PM

Thanks, Chris!

I am sure we will use this feature! Nice tip!

I just joined your blog listserv. I am looking forward to more great info. Thanks very much!

Sent to excel - column heading