topic reading numbers as text when importing from excel in SAS Procedures

reading numbers as text when importing from excel

deleted_user — Thu, 02 Sep 2010 12:11:40 GMT

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

Re: reading numbers as text when importing from excel

RickM — Thu, 02 Sep 2010 13:21:56 GMT

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!

Re: reading numbers as text when importing from excel

deleted_user — Thu, 02 Sep 2010 14:59:06 GMT

Thanks, that solves it!