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: 165
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: 165

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: 165

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

I got it. Thanks.

Community Manager
Posts: 2,697

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.

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

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