Doing an array and I want the formula in the array to be a lookup, something like this: data table.population; set table.population; Array income_(n) income_1 - income _100; Array age_(n) age_1-age_100; Do n=1 to 100; if n=1 then age_(n) = current_age; else age_(n) = age_(n-1)+1; end; Do n=1 to 100; income_(n) = lookup(age_(n), table.age_by_income, Income); end; the lookup would be somthing like a vlookup in excel, returning the income based on the age array.
... View more