topic Finding E values in SAS Programming

Finding E values

Babloo — Wed, 14 Feb 2018 14:33:16 GMT

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.

Re: Finding E values

Larrihoover — Wed, 14 Feb 2018 15:00:14 GMT

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

Re: Finding E values

ballardw — Wed, 14 Feb 2018 15:14:24 GMT

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.

Re: Finding E values

Babloo — Wed, 14 Feb 2018 15:30:55 GMT

No format has been applied to that variable.

Re: Finding E values

Babloo — Wed, 14 Feb 2018 16:05:55 GMT

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

Re: Finding E values

ballardw — Wed, 14 Feb 2018 16:53:59 GMT

@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.

Re: Finding E values

Babloo — Wed, 14 Feb 2018 16:56:55 GMT

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