05-16-2017 12:30 PM
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;
While importing, COLA and COLB gets correct value while COLC is generating all missing values.
05-16-2017 03:53 PM
Do you get any messages in the log? Post the code and messages from the log.
Is he formula actually: = 100 - A2
or does is have one of $ modifiers like = 100 - A$2 or 100 - $A2 ?
Does the cell address reference the result of another cell containing a formula?
Also depending on spreadsheet the variable may be getting assigned a numeric variable type in SAS but for some reason the result of the forumla is behaving like character and hence gets a missing value in SAS.
Easiest may be to SAVE As CSV and import the resulting CSV file.
05-17-2017 01:11 PM