As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Replace Missing Character Values with a Character String

From sasCommunity
Jump to: navigation, search

If you want to replace missing values of character variables with a string such as "***NOT ANSWERED***", you can use the COALESCEC function:

charvar = coalescec(charvar, "***NOT ANSWERED***");

Remember that the length of the substitution string cannot be greater than the length of the character variable. If it is, the string is truncated.

Submitted by Mike Zdeb. Contact me at my Discussion Page.

....see also

....see also