topic Sent to excel - column heading in SAS Enterprise Guide

Sent to excel - column heading

JSJ — Thu, 19 May 2016 20:22:28 GMT

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 — Thu, 19 May 2016 20:41:53 GMT

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

JSJ — Thu, 19 May 2016 21:03:45 GMT

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!