Friday, 16 October 2015

Data Step Tip: COMPBL Function

To take extra blanks out of a variable  (character), use the COMPBL function.

Example:

                                  BIGNAME="MARY  JANE                SMITH"

                                   SMALLER=COMPBL(BIGNAME);


Resulting in:

                                                  "MARY JANE SMITH"

No comments:

Post a Comment