BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
2 REPLIES 2
RickM
Fluorite | Level 6
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!
deleted_user
Not applicable
Thanks, that solves it!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1586 views
  • 0 likes
  • 2 in conversation