topic How to use PICTURE FORMAT? in New SAS User

How to use PICTURE FORMAT?

thepushkarsingh — Fri, 05 Jul 2019 09:47:20 GMT

Hi Can anyone help me understanding in how PICTURE FORMAT works?

I have following code, but it's formatting 1 million and 10 millions as same and mistaking bigger numbers -

proc format;

picture mill

0-high = ' 000.9M' (prefix='EUR ' mult=.000001);

run;

data _temp_;

input x ;

datalines;

1000000

10000000

100000000

1000000000

;

run;

data y;

set _temp_;

y = put(x,mill.);

run;

Output:

1000000      EUR 1M
10000000    EUR 1.0M
100000000   EUR 10.0M
1000000000 EUR 100.0M

Kurt_Bremser — Fri, 05 Jul 2019 10:42:30 GMT

From the documentation of the multiplier= option:

picture million low-high='09.9M'
        (prefix='$' mult=.00001);

So your code should be

proc format;
picture mill
  0-high = ' 009.9M' (prefix='EUR ' mult=.00001)
;
run;

The documentation will also tell you why this needs to be so.

thepushkarsingh — Fri, 05 Jul 2019 11:16:52 GMT

Many thanks