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.
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.
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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.