Traditional web-based reporting with SAS BI tools

Default value for data item in WRS

Reply
Contributor
Posts: 40

Default value for data item in WRS

Hi,

Is there a way to display default value like ( 0 or some default text ) instead of . (dot) when the data items are null in SAS WRS?

-Nithin.
SAS Super FREQ
Posts: 407

Re: Default value for data item in WRS

If you mean like setting a global property for the product, then, no, I'm afraid that you cannot do that.
Contributor
Posts: 40

Re: Default value for data item in WRS

No, I am not looking for global property of product.
I want a way to assign default value for data item. Kindly let me know if I am not clear.

-Nithin
SAS Employee
Posts: 238

Re: Default value for data item in WRS

You can create a custom data element for the measure (in Information Map Studio) you would like to display as 0 rather than MISSING.

Edit the expression of this new custom data element and set as:

sum(olddataname, 0)

~ Angela

Reference:
http://www.sascommunity.org/wiki/Tips:Convert_MISSING_to_0
Super Contributor
Posts: 356

Re: Default value for data item in WRS

Does setting the missing = 0 option in the autoexec for the workspace server (the one used by WRS) work?
SAS Super FREQ
Posts: 407

Re: Default value for data item in WRS

The MISSING= system option does not work for results returned by WRS.

See this new SAS note for another workaround at the data item (not global) level.

http://support.sas.com/kb/42/868.html
Ask a Question
Discussion stats
  • 5 replies
  • 314 views
  • 0 likes
  • 4 in conversation