Match identifiers
Posted: Mon Sep 17, 2018 7:09 am
Is is possible to match different identifier series? What I have in mind is something like VLOOKUP in Excel.
While there isn't a single function for that operation, I find you can usually accomplish that type of lookup by using an intermediate dummy series. In the following example, I lookup a value in series y corresponding the first observation for which series x equals 4.5.
Code: Select all
series tmp = x = 4.5
scalar result = y(@imax(tmp))