02-14-2018 09:33 AM
Assume I have a numeric variable called "amount" and it has values like -159000E.3, -1125590E.0, 17000987,0.9 etc . Is there any way to find only the exponential values of this variable? In the output I need only -159000E.3 and -1125590E.0
I find difficult to manually verify the values (it has over 10L unique values) for this variable.
02-14-2018 10:14 AM
Depending on what your current format is your question is equivalent to "is my value greater 1000000000" or similar. I have to say I'm not familiar with a format that will use scientific notation quite that way. I would expect to see something more like -1.59E9.
02-14-2018 11:53 AM
No format has been applied to that variable.
Show the proc contents result. EVERY variable in a SAS data set has a format. By default for numeric I would expect BEST12. But the values you show for example are not typical for best12.