Help using Base SAS procedures

reading numbers as text when importing from excel

Reply
N/A
Posts: 0

reading numbers as text when importing from excel

Hello,

I have an excel file, I am using proc import to read it in. One column is account numbers and instead of reading it in as a text it alters the format.

e.g. An account number might be 123456789 and in sas it ends up something like 1.23456E+12

I have been getting around it by putting apostrophes before it in excel but I need to find a more automated way.

Any help would be appreciated. I am sure I have fixed this before but can't remember how.

Shona
Regular Contributor
Posts: 165

Re: reading numbers as text when importing from excel

Posted in reply to deleted_user
Hi,

Try reading through this thread where someone else had a similar problem.

http://support.sas.com/forums/message.jspa?messageID=40589#40589

Good luck!
N/A
Posts: 0

Re: reading numbers as text when importing from excel

Thanks, that solves it!
Ask a Question
Discussion stats
  • 2 replies
  • 137 views
  • 0 likes
  • 2 in conversation