topic Re: How do we handle 2 decimal formats if we have data with "-" and 0 in SAS Programming

How do we handle 2 decimal formats if we have data with "-" and 0

noda6003 — Tue, 05 Jan 2021 15:22:15 GMT

I have data something which has negative values and 0 with decimals and i want 2 decimals for all non zero values.

I tried format=6.2 in proc report but it also makes 0 as 0.00. is there any way to skip 0 while using it in define in proc report?

PaigeMiller — Tue, 05 Jan 2021 15:28:09 GMT

A custom format ought to work

proc format;
    value custf 0=0 other=[6.2];
run;

Then in PROC REPORT

define var / format=custf.;

novinosrin — Tue, 05 Jan 2021 15:27:18 GMT

HI @noda6003 Please try using