topic Re: proc format picture does not display number 0 in SAS Programming

proc format picture does not display number 0

Nasser_DRMCP — Thu, 17 Aug 2017 10:22:13 GMT

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

Re: proc format picture does not display number 0

naveenraj — Thu, 17 Aug 2017 11:12:29 GMT

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

Re: proc format picture does not display number 0

Nasser_DRMCP — Thu, 17 Aug 2017 12:55:46 GMT

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)...

Re: proc format picture does not display number 0

naveenraj — Thu, 17 Aug 2017 13:03:41 GMT

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

please refer page 7 of this document.

Re: proc format picture does not display number 0

Nasser_DRMCP — Thu, 17 Aug 2017 13:14:18 GMT

great ! thanks for your quick and reliable response