Desktop productivity for business analysts and programmers

Import Excel 2010 with formulas into SAS EG

Reply
Occasional Contributor
Posts: 9

Import Excel 2010 with formulas into SAS EG

Hello ,

I will appreciate if somebody could help me with the following issue:

In the excel file I have one column that contains formula :  =IF([@Status]="File complete",IF([@[Customer Outcome]]="Customer accepted and documents signed","Uploaded",0),0)

The result is "Uploaded" or 0.

Once I try to import it into SAS EG , instead these values I get this new column with  value '4' for all the rows.

Does anybody can advise how to resolve this issue?

Thanks!

Ask a Question
Discussion stats
  • 0 replies
  • 239 views
  • 0 likes
  • 1 in conversation