Online File

How to use this page

---

Rick Aster: Professional SAS Programming Shortcuts: Contents

Chapter 16
Program
Value informats

---

PROC FORMAT;
INVALUE LVR (UPCASE JUST)
   'FALSE', 'NO', 'F', 'N', '0', '-' = 0
   'TRUE', 'YES', 'T', 'Y', '1', '+' = 1
   ;

INVALUE NZ (UPCASE JUST MIN=1 MAX=32)
   0 = _ERROR_
   OTHER = _SAME_
   ;

INVALUE ROMAN (UPCASE JUST MIN=1 MAX=32)
   ' ' = 0 'I' = 1 'II' = 2 'III' = 3 'IV' = 4 'V' = 5
   'VI' = 6 'VII' = 7 'VIII' = 8 'IX' = 9 'X' = 10
   'XI' = 11 'XII' = 12 'XIII' = 13 'XIV' = 14 'XV' = 15
   'XVI' = 16 'XVII' = 17 'XVIII' = 18 'XIX' = 19 'XX' = 20
   'XXI' = 21 'XXII' = 22 'XXIII' = 23 'XXIV' = 24 'XXV' = 25
   'XXVI'= 26 'XXVII'= 27 'XXVIII'= 28 'XXIX' = 29 'XXX' = 30
   ;

INVALUE YN (UPCASE JUST)
    'N' = 0
    'Y' = 1
    OTHER = .;

INVALUE MZERO (JUST)
    '.', ' ' = 0
    OTHER = _SAME_;

INVALUE HDT (UPCASE JUST)
    'A.M.', 'AM' = 0
    'P.M.', 'PM' = 43200;

INVALUE AZ (UPCASE JUST MIN=1)
    'A' = 1 'B' = 2 'C' = 3 'D' = 4 'E' = 5 'F' = 6 'G' = 7 'H' = 8
    'I' = 9 'J' = 10 'K' = 11 'L' = 12 'M' = 13 'N' = 14 'O' = 15
    'P' = 16 'Q' = 17 'R' = 18 'S' = 19 'T' = 20 'U' = 21 'V' = 22
    'W' = 23 'X' = 24 'Y' = 25 'Z' = 26 'AA' = 27 'BB' = 28
    'CC' = 29 'DD' = 30 'EE' = 31 'FF' = 32 'GG' = 33
    'HH' = 34 'II' = 35 'JJ' = 36 'KK' = 37 'LL' = 38
    'MM' = 39 'NN' = 40 'OO' = 41 'PP' = 42 'QQ' = 43
    'RR' = 44 'SS' = 45 'TT' = 46 'UU' = 47 'VV' = 48
    'WW' = 49 'XX' = 50 'YY' = 51 'ZZ' = 52;

INVALUE GP (UPCASE JUST)
    'A' = 4 'B' = 3 'C' = 2 'D' = 1 'F' = 0
    OTHER = .;
RUN;