How do I import a particular column in Excel which utilize Formula to generate values using PROC IMPORT? I am using following code and per my understanding SAS should automatically generate values in the field solving formula. Ex. Excel File: COL_C is based on the formula (100-COLA). proc import datafile= "..\Temp\test.xlsx" dbms=xlsx out= test replace; sheet="temp"; getnames=YES; run; quit; While importing, COLA and COLB gets correct value while COLC is generating all missing values.
... View more