- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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!