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!
This is great, thanks for the tip, geoffatkins!
Thank you for the exact answer. Helpful.
Cheer up!
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.
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.
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.
GOD BLESS YOU!!!! YOU SAVED ME!!!!!! THANK YOU THANK YOU THANK YOU!!!!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: