Get column name when copy data directly from SAS dataset

deleted_user · Posted 05-14-2009 09:53 PM

Hi,

When opening a SAS dataset in SAS EG4, we can use Ctrl+A to select all the data and then copy. However when pasting the data in Excel, it only pastes the actual data value and drops column names. Does anyone know how to get the column names when using this method to export data to Excel? Thanks!

andreas_lds · Posted 05-15-2009 02:51 AM

Right click on the dataset in the project explorer, and select Send to > Excel.

deleted_user · Posted 05-18-2009 03:09 AM

The file getting from Send to > Excel is not really an Excel file because it does not accept the pre-defined cells' format i.e. font or board format.

Get column name when copy data directly from SAS dataset

Re: Get column name when copy data directly from SAS dataset

Re: Get column name when copy data directly from SAS dataset

Get column name when copy data directly from SAS dataset

Re: Get column name when copy data directly from SAS dataset

Re: Get column name when copy data directly from SAS dataset

Ready to join fellow brilliant minds for the SAS Hackathon?

Click image to register for webinar

Classroom Training Available!