Hi, Is it possible to create a data step that comes from a variable? I have a table with ref, amount and tariff. The total_cost must be calculated with the 'formula' provided in tariff, where the 'formula' also uses the amount in the calculation. (This is just an example, where the 'formula' could be anything else and also use other variables). I did try lots of things, like with macro variables, call execute, etc.., but no luck. Thanks! data tars;
input REF 1-8 AMOUNT 10-11 TARIFF $ 13-34;
datalines;
10655094 5 12+ifn(AMOUNT>=12,6,0)
10655234 10 16+ifn(AMOUNT>=10,4,0)
;
run;
data prep;
set tars;
CALC_STRING = cats('TOTAL_COST=',TARIFF,';');
* >> how to 'execute' the calc_string at this point? *;
run;
... View more