DATA Step, Macro, Functions and more

Finding E values

Reply
Super Contributor
Posts: 619

Finding E values

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.

Occasional Contributor
Posts: 16

Re: Finding E values

Super Contributor
Posts: 619

Re: Finding E values

Posted in reply to Larrihoover
Could you please help me understand how that format applies to my scenario?
Super User
Posts: 13,066

Re: Finding E values

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.

Super Contributor
Posts: 619

Re: Finding E values

No format has been applied to that variable.
Super User
Posts: 13,066

Re: Finding E values


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.

Super Contributor
Posts: 619

Re: Finding E values

Yes, it's in Best12. Format. You can ignore my example which is not adhere
to best12. Format.
Ask a Question
Discussion stats
  • 6 replies
  • 92 views
  • 0 likes
  • 3 in conversation