Page 1 of 1

Transforming data (keep values only larger than 2.6)

Posted: Fri Feb 02, 2018 5:38 am
by ppoulimen
Hi all, I am newbie in e-views
I have an excel with three (numeric values) columns.

I import successfully the data creating three objects (A,B,C) and I want to modify the data in the
C object keeping rows with values larger than 2.6.

Could you please help me how can I do it ?
(Either with command or graphically)

I suppose that all the objects should be modified as group.

Thanks a lot for your assistance

Re: Transforming data (keep values only larger than 2.6)

Posted: Fri Feb 02, 2018 8:52 am
by EViews Gareth
You'll have to be more precise. What do you want to do with observations where C is not > 2.6?

Re: Transforming data (keep values only larger than 2.6)

Posted: Sat Feb 03, 2018 2:30 am
by ppoulimen
EViews Gareth wrote:You'll have to be more precise. What do you want to do with observations where C is not > 2.6?


I have made a linear regression first (ls A con B C)
and I would like to make the transformation to C data in order to make a second regression ((ls new_A con new_B new_C)) and compare the results.

I have attached the initial data in excel file (data.xls) and the data I want after the transformation.

Re: Transforming data (keep values only larger than 2.6)

Posted: Sat Feb 03, 2018 10:43 am
by EViews Gareth
It still is really unclear as to what you want to do.

But I'm going to guess you just want to set the sample so that c>2.6

Re: Transforming data (keep values only larger than 2.6)

Posted: Sun Feb 04, 2018 12:19 am
by ppoulimen
EViews Gareth wrote:It still is really unclear as to what you want to do.

But I'm going to guess you just want to set the sample so that c>2.6


Yes , I want to keep only the values larger than 2.6 in the third variable object (column C)

Re: Transforming data (keep values only larger than 2.6)

Posted: Sun Feb 04, 2018 8:45 am
by EViews Gareth
So set the sample such that c>2.6