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
Transforming data (keep values only larger than 2.6)
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Transforming data (keep values only larger than 2.6)
You'll have to be more precise. What do you want to do with observations where C is not > 2.6?
Follow us on Twitter @IHSEViews
Re: Transforming data (keep values only larger than 2.6)
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.
- Attachments
-
- new_data.xls
- (25.5 KiB) Downloaded 268 times
-
- data.xls
- (28.5 KiB) Downloaded 273 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Transforming data (keep values only larger than 2.6)
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
But I'm going to guess you just want to set the sample so that c>2.6
Follow us on Twitter @IHSEViews
Re: Transforming data (keep values only larger than 2.6)
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)
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Transforming data (keep values only larger than 2.6)
So set the sample such that c>2.6
Follow us on Twitter @IHSEViews
Who is online
Users browsing this forum: No registered users and 22 guests