The SAS Output Delivery System and reporting techniques

Get column name when copy data directly from SAS dataset

Reply
N/A
Posts: 0

Get column name when copy data directly from SAS dataset

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!
Super Contributor
Posts: 265

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

Right click on the dataset in the project explorer, and select Send to > Excel.
N/A
Posts: 0

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

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.
Ask a Question
Discussion stats
  • 2 replies
  • 136 views
  • 0 likes
  • 2 in conversation