Default value for data item in WRS

[Nithin]

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.

[Madelyn_SAS]

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

[Nithin]

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

[AngelaHall]

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

[twocanbazza]

Does setting the missing = 0 option in the autoexec for the workspace server (the one used by WRS) work?

[Madelyn_SAS]

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