topic Re: Copy and paste: Excel data into SAS studio-University edition in SAS Studio

Copy and paste: Excel data into SAS studio-University edition

geoffatkins — Sat, 20 Sep 2014 18:34:36 GMT

Previously while working with the standard installed version of SAS 9.3 installed on a windows machine, you could copy data from excel table to SAS work space without a problem.

I recently installed the free university edition of SAS and tried doing the same unsuccessfully. After playing about with the data for a little while, I realized that if you copy data directly from excel, SAS interprets different columns as white spaces/ tabs and merges data causing an erroneous data table.

To correct this you would need to remove tabs/ white spaces from your data in excel before copying into SAS university edition. You can do this in text file (note pad) or using the tool provided here: Remove Extra Whitespace and Tab Space

Hopefully this saves someone some headache!

Re: Copy and paste: Excel data into SAS studio-University edition

AnnaBrown — Mon, 22 Sep 2014 17:33:12 GMT

This is great, thanks for the tip, geoffatkins!

Re: Copy and paste: Excel data into SAS studio-University edition

Tsegazaab — Thu, 25 Aug 2016 04:55:05 GMT

Thank you for the exact answer. Helpful.

Cheer up!

Re: Copy and paste: Excel data into SAS studio-University edition

YTH — Tue, 02 Jul 2019 20:05:12 GMT

I noticed that I cannot copy data from excel and paste it on SAS studio today.

Thanks a lot for providing the information to solve the problem.

Re: Copy and paste: Excel data into SAS studio-University edition

Tom — Tue, 02 Jul 2019 20:39:14 GMT

What is the issue with pasting values from Excel into SAS/Studio?

I don't have any issue copy and pasting into SAS/studio interface running a full version of SAS and using Chrome as the brower.

Note that I have the Editor option to automatically convert tabs into spaces checked.

Re: Copy and paste: Excel data into SAS studio-University edition

YTH — Tue, 02 Jul 2019 21:11:19 GMT

If you just copy data from excel or your computer SAS software, then the
SAS studio cannot read that data that you paste. So, I need to replace
white space and tabs with a single space in order to let SAS studio read
the data correctly.

I am using Mac with Safari for my SAS studio

Re: Copy and paste: Excel data into SAS studio-University edition

Tom — Wed, 03 Jul 2019 12:42:30 GMT

I still not sure I understand the issue.

Are you saying you can't get it to copy and paste? Are you using mouse buttons or pressing keys to copy and paste? Try using the other way if one doesn't work.

Or are you saying the value that is pasted is garbled in some way? If so how is it garbled?

Is it pasting it like a block copy so that the inserted text is mixed with the text that is already on the following lines? If so then perhaps you should just paste to the end of the file and then move it where you want it. Or paste into a separate editor window.

Re: Copy and paste: Excel data into SAS studio-University edition

SaraAguilar — Thu, 01 Sep 2022 22:15:02 GMT

GOD BLESS YOU!!!! YOU SAVED ME!!!!!! THANK YOU THANK YOU THANK YOU!!!!!