proc format picture does not display number 0

[Nasser_DRMCP]

Hello,

A dataset has a numeric column with values 0, 1, 2, 3.

I would like to print these numbers with a "€" prefix. so my code is

proc format ; picture Format_Year_Suite low-high = '0' (prefix='€ ') ; run;

proc print data=BEH_INDIC_7 ;

var Suite_Year_4_Sort ;

format Suite_Year_4_Sort Format_Year_Suite. ;

run ;

It works for all numbers execpt 0 which is not displayed

[naveenraj · Accepted solution]

When you specify zero as the digit selector, any leading zeros in the number to be displayed are shown as blanks

proc format ; picture Format_Year_Suite low-high = '9' (prefix='€ ') ; run;

This should work for you 

[Nasser_DRMCP]

thanks a lot naveenraj. but whenever there are more than 10 years, 10 is diplayed N + 0 (N + 10 intended), 11 is displayed N + 1 (N + 11 intended)...

[naveenraj]

http://www2.sas.com/proceedings/sugi31/243-31.pdf 

please refer page 7 of this document.

[Nasser_DRMCP]

great ! thanks for your quick and reliable response