topic Re: Default value for data item in WRS in SAS Web Report Studio

Default value for data item in WRS

Nithin — Wed, 23 Mar 2011 19:16:58 GMT

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.

Re: Default value for data item in WRS

Madelyn_SAS — Wed, 23 Mar 2011 22:29:09 GMT

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

Re: Default value for data item in WRS

Nithin — Thu, 24 Mar 2011 14:44:52 GMT

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

Re: Default value for data item in WRS

AngelaHall — Thu, 24 Mar 2011 18:42:36 GMT

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

Re: Default value for data item in WRS

twocanbazza — Thu, 24 Mar 2011 18:43:34 GMT

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

Re: Default value for data item in WRS

Madelyn_SAS — Wed, 06 Apr 2011 18:09:10 GMT

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