COMPBL(Compress blanks)
!) Function: COMPBL Purpose: To replace all occurrences of two or more blanks with a single blank character. This is particularly useful for standardizing addresses and names where multiple blanks may have been entered. Syntax : COMPBL(character-value) character-value is any SAS character value. If a length has not been previously assigned, the length of the resulting variable will be the length of the argument Example: Using the Combl function to convert multiple blanks to single blank. ***Primary function: COMPBL; data squeeze; input # 1 @ 1 Name $20. # 2 @ 1 Address $30. # 3 @ 1 City $15. @ 20 State $2. @ 25 Zip $5. ; Name = compbl(Name); Address = compbl(Address); City...