topic Converting character stored in scientific notation?? in SAS Programming

Converting character stored in scientific notation??

hbergen — Wed, 25 Jul 2012 14:40:48 GMT

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.

Re: Converting character stored in scientific notation??

Astounding — Wed, 25 Jul 2012 15:42:32 GMT

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.

Re: Converting character stored in scientific notation??

_maldini_ — Thu, 28 Jul 2016 20:05:17 GMT

@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!