Write and run SAS programs in your web browser

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

Reply
New User
Posts: 1

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

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!

Community Manager
Posts: 564

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

Posted in reply to geoffatkins

This is great, thanks for the tip, geoffatkins!

New Contributor
Posts: 3

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

Posted in reply to AnnaBrown

Thank you for the exact answer. Helpful.

Cheer up!

Ask a Question
Discussion stats
  • 2 replies
  • 1439 views
  • 2 likes
  • 3 in conversation