Friday, June 29, 2018

SAS: Blank when zero

SAS: Blank when zero



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




Sample usage

format 
  units_sold 
  units_returned 
    bwz7. ;



Tuesday, June 26, 2018

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");