topic Re: How to format the number? in SAS Programming

How to format the number?

ybz12003 — Tue, 31 Oct 2017 16:31:35 GMT

Hello:

I found number format is different in the column of "Pval". One is 1E-6 and the other one is 0.00001. I used format best8.6, I found it still shows 1E-6. If I would like to get all of numbers format in the "0.000001", please advice how to approach. Thanks.

data want;

set have;

format Pval best 8.6;

run;

Re: How to format the number?

Reeza — Tue, 31 Oct 2017 16:38:25 GMT

You should review how formats are specified, what the portion means after the decimal point especially and the concept of the width. This is all available in the documentation.

Re: How to format the number?

kiranv_ — Tue, 31 Oct 2017 16:42:13 GMT

see this link for a detailed answer

https://communities.sas.com/t5/Base-SAS-Programming/What-is-quot-Best12-quot-and-quot-f16-quot-meaning/td-p/261758