SAS EG Version: 7.15 (7.100.5.5850) (64-bit) I am importing data from an Excel workbook. One of my data columns is "Cost" (spend in USD). The column in Excel is formatted as Number. When importing this data into SAS the are usually no issues. However, if the "Cost" has zero cents, i.e. the value ends with ".00" (e.g. 1760.00), then SAS is dividing the number by 100/shifting the decimal place over 2 points. E.g. 1760.00 becomes 17.60 The Source Informat and Output Format/Output Informat are BEST12. Can anyone assist in preventing this decimal shift from happening? I would just like to keep the imported number values as "XXXX.00"
... View more
