09-20-2014 02:34 PM
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!