SAS: Blank when zero

SAS: Blank when zero



* blank when zero ;
proc format;
  value bwz
  0 = ' '
;



Sample usage

format 
  units_sold 
  units_returned 
    bwz7. ;

SAS: Remove unicode characters from string field

Remove unicode characters from string field


* remove unicode characters. For example grave accent + H is Omega symbol. ;
* Source: https://communities.sas.com/t5/SAS-Procedures/SAS8-How-to-remove-special-characters-from-string/td-p/59186 ;

keyboard = "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890`~!@#$%^&*()-_=+\|[]{};:',.<>?/ ";

stringField = compress(stringField, keyboard, "kis");