Converting character stored in scientific notation??

Reply
N/A
Posts: 1

Converting character stored in scientific notation??


I am hoping there is an easy solution to this that I'm overlooking, but here is my problem:

I have a CHARACTER value stored as '8.8242e+13'

I would like to convert this to a character value stored as '88242000000000'

I would greatly appreciate any suggestions.

Respected Advisor
Posts: 4,948

Re: Converting character stored in scientific notation??

The conversions aren't difficult, although you may need to consider a couple of questions.  How many characters should be used to store the final character variable?  Should the results be left-justified or right-justified?  Here's one approach:

new_variable = put( input(old_variable,10.), best14.);

Good luck.

Regular Contributor
Posts: 199

Re: Converting character stored in scientific notation??

@Astounding

 

I have a similar question.

 

I have a variable whose values are numbers. Some of the values are listed in scientific notation, the majority are simply strings of numbers. I want the variable to be numeric and w/o the scientific notation.

 

When I read-in the data using a DATA step, and apply a character informat ($20.), the numbers no longer have the scientific notation. Great, except when I convert the character variable to numeric, the scientific notation returns.

 

numeric_Part_FB_ID = INPUT (Part_FB_ID, BEST32.);

 

When I read-in the data and apply a numeric informat (BEST32.), the values are listed in scientific notation.

 

What am I doing wrong here? 

 

Thanks!

 

 

 

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