Is there a way to tell EG to multiply all the values in a SAS table times a single number in an Excel reference table?
Basically, we have a reference table with a number of values, where every single value must be multiplied against a single variable rate to be searched for within a separate Excel table. We would hard-code this number, but the rates change frequently. And, different formulas need to call different rates within the Excel file.
So far, we have been able to import the Excel table into my EG project. However, EG keeps asking us to join the Excel table to our data, which is impossible (the Excel file, as a reference table, only has two columns: Label and Rate, with one rate per row, none of which can be used to join).
Thanks in advance for your help. JL