topic Re: Showing the full number, avoiding scientific notation in New SAS User

Showing the full number, avoiding scientific notation

Nini1 — Tue, 13 Oct 2020 08:04:31 GMT

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

Re: Showing the full number, avoiding scientific notation

Amir — Tue, 13 Oct 2020 08:22:09 GMT

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.

Re: Showing the full number, avoiding scientific notation

Kurt_Bremser — Tue, 13 Oct 2020 08:28:52 GMT

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.

Re: Showing the full number, avoiding scientific notation

Nini1 — Sun, 18 Oct 2020 19:34:45 GMT

Thank you very much!