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

[geoffatkins]

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!

[AnnaBrown]

This is great, thanks for the tip, geoffatkins!

[Tsegazaab]

Thank you for the exact answer. Helpful.

Cheer up!

[YTH]

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.

[Tom]

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. 

[YTH]

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

[Tom]

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.

[SaraAguilar]

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