Transforming data (keep values only larger than 2.6)

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

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

ppoulimen
Posts: 6
Joined: Thu Feb 01, 2018 12:03 pm

Transforming data (keep values only larger than 2.6)

Postby ppoulimen » Fri Feb 02, 2018 5:38 am

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11735
Joined: Tue Sep 16, 2008 5:38 pm

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

Postby EViews Gareth » Fri Feb 02, 2018 8:52 am

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

ppoulimen
Posts: 6
Joined: Thu Feb 01, 2018 12:03 pm

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

Postby ppoulimen » Sat Feb 03, 2018 2:30 am

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 19 times
data.xls
(28.5 KiB) Downloaded 19 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11735
Joined: Tue Sep 16, 2008 5:38 pm

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

Postby EViews Gareth » Sat Feb 03, 2018 10:43 am

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
Follow us on Twitter @IHSEViews

ppoulimen
Posts: 6
Joined: Thu Feb 01, 2018 12:03 pm

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

Postby ppoulimen » Sun Feb 04, 2018 12:19 am

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)

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11735
Joined: Tue Sep 16, 2008 5:38 pm

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

Postby EViews Gareth » Sun Feb 04, 2018 8:45 am

So set the sample such that c>2.6
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 1 guest