@Rmean excluding one of the variables

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

vytama
Posts: 53
Joined: Wed Dec 19, 2012 11:05 am

@Rmean excluding one of the variables

Postby vytama » Wed Mar 14, 2018 8:17 am

Hello,

I am on Eviews 10. I have a group A that has 5 series (!i=1 to 5 and !j=1 to @rows(A)). I would like to calculate @rmean and place in a new group B for each row (!j=1 to end) but I would like to exclude one of the variables. For instance, when !i=1, @rmean would count only series 2 to 5, if when !i=2, @rmean would count 1st and 3-5 series and so on. What is the best way to do that?

Thank you.

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

Re: @Rmean excluding one of the variables

Postby EViews Gareth » Wed Mar 14, 2018 8:27 am

Create new groups equal to the initial group, drop the series you want, then use @rmean.

Something like:

Code: Select all

group g2 g1
g2.drop !i
=@rmean(g2)
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 5 guests