Please help me understand why the column ending in "BAD" formats the input ending with 00 like that. I would have expected the same results.   DATA PAY_FILE ;     LENGTH OUTSTANDING_BAL $ 15 ;     FORMAT OUTSTANDING_BAL $CHAR15. ;      INPUT  OUTSTANDING_BAL $ ;      CARDS;      000000000120584      000000000005073      000000000008371      000000000001000      000000000081000      000000000009000      ; RUN;   DATA PAY_FILE; SET PAY_FILE; FORMAT OUTSTANDING_BAL_OK1 dollar20.2; OUTSTANDING_BAL_OK1 = INPUT(STRIP(INPUT(CAT(SUBSTR(OUTSTANDING_BAL,1,LENGTH(OUTSTANDING_BAL)-2),".",SUBSTR(OUTSTANDING_BAL,LENGTH(OUTSTANDING_BAL)-1,2)),20.)),10.); OUTSTANDING_BAL_OK2 = INPUT(STRIP(INPUT(CAT(SUBSTR(OUTSTANDING_BAL,1,LENGTH(OUTSTANDING_BAL)-2),".",SUBSTR(OUTSTANDING_BAL,LENGTH(OUTSTANDING_BAL)-1,2)),20.)),10.); OUTSTANDING_BAL_BAD = INPUT(STRIP(INPUT(CAT(SUBSTR(OUTSTANDING_BAL,1,LENGTH(OUTSTANDING_BAL)-2),".",SUBSTR(OUTSTANDING_BAL,LENGTH(OUTSTANDING_BAL)-1,2)),20.)),DOLLAR20.2); RUN;     ... View more