topic Re: show zero rather than "." in SAS Web Report Studio

show zero rather than "."

plkkw — Fri, 04 May 2012 10:08:41 GMT

I have a cross-tab report, and there are many null values in the figure of cross-tab table. In web report studio, it shows a "." for null value. It is very strange, can I change any setting to change it so that null value shows '0" (zero) rather than ".".

Re: show zero rather than "."

shivas — Fri, 04 May 2012 10:32:57 GMT

Hi,

how about using condition highlighting.

Thanks,

Shiva

Re: show zero rather than "."

plkkw — Sat, 05 May 2012 03:47:20 GMT

there is a user-defined format, can it achieve my task?

Re: show zero rather than "."

shivas — Sat, 05 May 2012 05:05:34 GMT

Hi,

You can also do by writing expression in Imap.

(case when Account_Type . then 0 else Account_Type

end) as Columnname

Thanks,

Shiva

Re: show zero rather than "."

plkkw — Sat, 05 May 2012 09:39:26 GMT

Hi shivas,

when i enter "case when <<t1.f1>> NULL then 0 <<t1.f1>> end" in expression editor of data-item through information map studio. There is error shown:

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IS, LE, LET, LIKE, LT, LTT, NE,NET OR, ^=, }, }}, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

** the data type of the field involved is number

Re: show zero rather than "."

Patrick — Sun, 06 May 2012 00:09:56 GMT

One of below tips should do:

http://www.sascommunity.org/wiki/Tips:Convert_MISSING_to_0

http://www.sascommunity.org/wiki/Tips:Replace_Missing_Character_Values_with_a_Character_String

Re: show zero rather than "."

shivas — Sun, 06 May 2012 06:58:22 GMT

Hi,

Try this..I have changed your expression.

case when <<t1.f1>>=. then 0 else <<t1.f1>> end

Thanks,

Shiva

Re: show zero rather than "."

SAPPER — Tue, 08 May 2012 13:41:11 GMT

You could also try to use a coalesce function with a 0 and the column on which you are reporting

Re: show zero rather than "."

UlfB — Wed, 16 May 2012 11:17:08 GMT

To clarify SAPPER's reply, one way of fixing it is to change the expression in the infomap to:

CoalesceEmpty(<<t1.f1>>, 0)