Showing the full number, avoiding scientific notation

[Nini1]

Hello everyone,

I have some problem with one variable. Some values are shown with 'e' , with scientific notation. I tried to format with best32. but it does not work. Could you please suggest any solution to this problem?

Thank you in advance

[Amir]

Hi,

Please provide some sample data and equivalent sample output, as well as the code used to create the output from the input. Please use the formatting tools provided to post code and data.

If you are reading from Excel then it is possible the scientific notation is what the raw data looks like.

Kind regards,

Amir.

[Kurt_Bremser · Accepted solution]

As soon as the exponent goes beyond 31, you will get the scientific notation; just run this for illustration:

data test;
format number best32.;
do i = 1 to 33;
  number = 10 ** i;
  output;
end;
run;

You can also see how, from a given exponent, the limits of numeric precision kick in and create artifacts.

[Nini1]

Thank you very much!