Finding E values

[Babloo]

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.

[Larrihoover]

I think you just need to reformat to get what you want: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000205131.htm

[Babloo]

Could you please help me understand how that format applies to my scenario?

[ballardw]

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.

[Babloo]

No format has been applied to that variable.

[ballardw]

---

@Babloo wrote:
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.

[Babloo]

Yes, it's in Best12. Format. You can ignore my example which is not adhere
to best12. Format.