topic Re: Proc format for negative values in ODS and Base Reporting

Proc format for negative values

david27 — Wed, 22 Feb 2023 17:33:47 GMT

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 — Wed, 22 Feb 2023 18:12:20 GMT

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 — Wed, 22 Feb 2023 18:38:46 GMT

What is

'0,000,000,009'

anyways?

Reeza — Wed, 22 Feb 2023 18:44:06 GMT

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:

david27 — Wed, 22 Feb 2023 18:46:09 GMT

Thank You @Reeza