topic Re: Shortcut keys to copy the SAS dataset with variable names in Excel. in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Shortcut-keys-to-copy-the-SAS-dataset-with-variable-names-in/m-p/194869#M14832 <HTML><HEAD></HEAD><BODY><P>I got it. Thanks.</P></BODY></HTML> Thu, 05 Mar 2015 07:17:14 GMT RamKumar 2015-03-05T07:17:14Z Shortcut keys to copy the SAS dataset with variable names in Excel. https://communities.sas.com/t5/SAS-Enterprise-Guide/Shortcut-keys-to-copy-the-SAS-dataset-with-variable-names-in/m-p/194868#M14831 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 05 Mar 2015 06:33:16 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Shortcut-keys-to-copy-the-SAS-dataset-with-variable-names-in/m-p/194868#M14831 RamKumar 2015-03-05T06:33:16Z Re: Shortcut keys to copy the SAS dataset with variable names in Excel. https://communities.sas.com/t5/SAS-Enterprise-Guide/Shortcut-keys-to-copy-the-SAS-dataset-with-variable-names-in/m-p/194869#M14832 <HTML><HEAD></HEAD><BODY><P>I got it. Thanks.</P></BODY></HTML> Thu, 05 Mar 2015 07:17:14 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Shortcut-keys-to-copy-the-SAS-dataset-with-variable-names-in/m-p/194869#M14832 RamKumar 2015-03-05T07:17:14Z Re: Shortcut keys to copy the SAS dataset with variable names in Excel. https://communities.sas.com/t5/SAS-Enterprise-Guide/Shortcut-keys-to-copy-the-SAS-dataset-with-variable-names-in/m-p/194870#M14833 <HTML><HEAD></HEAD><BODY><P>For the benefit of others:</P><P></P><P>From the data view, select <STRONG>Send To-&gt;Microsoft Excel</STRONG></P><P><STRONG><IMG alt="sendto.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/9451_sendto.png" width="450" /></STRONG></P><P>For quick, partial data, right-click in on a selection of data cells and select <STRONG>Copy with Headers</STRONG></P><P><STRONG><IMG alt="copywithheaders.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/9452_copywithheaders.png" width="450" /></STRONG></P><P>This copies the selected data as tab-delimited values, with column headers -- perfect for pasting into a spreadsheet.</P><P></P><P>Chris</P></BODY></HTML> Thu, 05 Mar 2015 13:11:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Shortcut-keys-to-copy-the-SAS-dataset-with-variable-names-in/m-p/194870#M14833 ChrisHemedinger 2015-03-05T13:11:44Z