Help using Base SAS procedures

Excel :Reading Exponentials

Reply
Regular Contributor
Posts: 229

Excel :Reading Exponentials

Hi I am having a numeric variable(accno) having 20 digits but when i am importing it in to sas it was showing exponentials how can i Resolve this.
I have converted the variables in to Charrater by adding a character variable .But the (account no) is not getting correctly

Ex: 19867839765432678098 out:1.90E98

Pl let me know
Respected Advisor
Posts: 4,173

Re: Excel :Reading Exponentials

Import the account number with informat $20.

Never store an account number in a numeric variable.

You can't store 20 digits in a numeric SAS variable with full precision - and you sure don't want to change account numbers when rounding happens ;-)

HTH
Patrick
Ask a Question
Discussion stats
  • 1 reply
  • 149 views
  • 0 likes
  • 2 in conversation