How to use PICTURE FORMAT?

[thepushkarsingh]

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 · Accepted solution]

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]

Many thanks