Page 1 of 1

Vlookup in EViews

Posted: Mon Mar 04, 2013 5:04 am
by benlambert18785
Hi,

I would like to do the following: Lookup a number within a matrix/series. If that number is contained within that series I would then do something, if it is not I would do something else.

Is there a way to do this in EViews?

Thanks,

Ben

Re: Vlookup in EViews

Posted: Mon Mar 04, 2013 8:35 am
by EViews Gareth
In a series:

Code: Select all

smpl if X=0.05 if @obssmpl>0 then 'do stuff endif
i.e. set the sample to every observation for which X is equal to 0.05. Then count the number of observations in the sample (obssmpl), and if it is greater than 0, do something.