BookmarkSubscribeRSS Feed
Nithin
Calcite | Level 5
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.
5 REPLIES 5
Madelyn_SAS
SAS Super FREQ
If you mean like setting a global property for the product, then, no, I'm afraid that you cannot do that.
Nithin
Calcite | Level 5
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
SAS Employee
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
Quartz | Level 8
Does setting the missing = 0 option in the autoexec for the workspace server (the one used by WRS) work?
Madelyn_SAS
SAS Super FREQ
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

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1745 views
  • 0 likes
  • 4 in conversation