/* Format your numbers like a social media superstar */ /* Provided for example purposes only by Chris Hemedinger */ libname library (work); proc format lib=library; value linkedin 500 - high ='500+' ; run; data followers; length name $ 40 followers 8 displayed 8; format displayed linkedin.; infile datalines dsd; input name followers; displayed = followers; datalines; Chris Hemedinger, 776 Kevin Bacon, 100543 Norman Newbie, 3 Colleen Connector, 499 ; run; proc format lib=library; picture social (round) 1E03-<1000000='000K' (mult=.001 ) 1E06-<1000000000='000.9M' (mult=.00001) 1E09-<1000000000000='000.9B' (mult=1E-08) 1E12-<1000000000000000='000.9T' (mult=1E-11); run; /* test data */ data likes (keep=actual displayed); format actual comma20. displayed social.; do i=1 to 12; actual=16**i; displayed = actual; output; end; run;