Retain Formulas when Loading Excel to SAS
To retain formulas, first you need to designate the column as "FORMULA" in the MPE_EXCEL_CONFIG table. The target column (in SAS) should be character, with a width big enough to support your longest formula.
If position is important you should ensure you have a sequential key.
For more information: https://docs.datacontroller.io/excel