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 ".".
Hi,
how about using condition highlighting.
Thanks,
Shiva
there is a user-defined format, can it achieve my task?
Hi,
You can also do by writing expression in Imap.
(case when Account_Type . then 0 else Account_Type
end) as Columnname
Thanks,
Shiva
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
Hi,
Try this..I have changed your expression.
case when <<t1.f1>>=. then 0 else <<t1.f1>> end
Thanks,
Shiva
You could also try to use a coalesce function with a 0 and the column on which you are reporting
To clarify SAPPER's reply, one way of fixing it is to change the expression in the infomap to:
CoalesceEmpty(<<t1.f1>>, 0)
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.