Match identifiers

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

stefanp
Posts: 63
Joined: Wed Sep 30, 2015 12:24 am

Match identifiers

Postby stefanp » 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.

EViews Matt
EViews Developer
Posts: 557
Joined: Thu Apr 25, 2013 7:48 pm

Re: Match identifiers

Postby EViews Matt » Mon Sep 17, 2018 9:46 am

Hello,

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))


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 9 guests