Proc format for negative values

[david27]

I have this existing code. But it does not display negative values.

All negative values show up as positive value.

What can be an alternative way here?

	proc Format ;
		picture  NumFmt
			0 = ' '
			other = '000,000,009'
		;Quit;

[PaigeMiller · Accepted solution]

Negative values falls under "Other".

Try this:

proc format ;
    picture numfmt
        low-<0='0,000,000,009' (prefix='-')
        0 = ' '
        0<-high= '000,000,009';
run;

That should work, but you don't really need picture formats here.

proc format;
    value numfmt 0=' ' other=[comma12.0];
run;

[david27]

Thank You @PaigeMiller 

What is 

'0,000,000,009'

anyways? 

[Reeza]

9 prints zeroes, zeroes print blanks.

It's called a digit selector in SAS.

See page 6/7 of this document for an example that clarifies it more:

https://support.sas.com/resources/papers/proceedings/proceedings/sugi31/243-31.pdf

[david27]

Thank You @Reeza