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