Desktop productivity for business analysts and programmers

Shortcut keys to copy the SAS dataset with variable names in Excel.

Accepted Solution Solved
Reply
Regular Contributor
Posts: 168
Accepted Solution

Shortcut keys to copy the SAS dataset with variable names in Excel.

Any shortcut keys available in EG 7.1 to copy\paste the SAS dataset to Excel along with variable names? I don't wish to export the dataset every time.


Accepted Solutions
Solution
‎03-05-2015 02:17 AM
Regular Contributor
Posts: 168

Re: Shortcut keys to copy the SAS dataset with variable names in Excel.

I got it. Thanks.

View solution in original post


All Replies
Solution
‎03-05-2015 02:17 AM
Regular Contributor
Posts: 168

Re: Shortcut keys to copy the SAS dataset with variable names in Excel.

I got it. Thanks.

Community Manager
Posts: 2,887

Re: Shortcut keys to copy the SAS dataset with variable names in Excel.

For the benefit of others:

From the data view, select Send To->Microsoft Excel

sendto.png

For quick, partial data, right-click in on a selection of data cells and select Copy with Headers

copywithheaders.png

This copies the selected data as tab-delimited values, with column headers -- perfect for pasting into a spreadsheet.

Chris

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 778 views
  • 0 likes
  • 2 in conversation