topic Re: Numeric formatting issue help in SAS Programming

Numeric formatting issue help

Q1983 — Wed, 25 Jul 2018 19:53:23 GMT

data have;

num = 3298056;

pct = 46.51644;

avg = 1.2555

run;

What is the best way to format the numbers to capture proper commas and to capture the numbers up to 2 decimal places only

So num = 3,298,056 pct = 46.52 avg = 1.25

Re: Numeric formatting issue help

PaigeMiller — Wed, 25 Jul 2018 19:56:09 GMT

You can use different formats for each variable. So for NUM, use the COMMA format, and for PCT and AVG, you can use best10.2 (or similar, there are many choices that will work)