Creating an index

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

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

miorinnovo
Posts: 199
Joined: Sun Mar 01, 2015 5:01 pm

Creating an index

Postby miorinnovo » Mon Mar 23, 2015 10:44 am

I have a quarterly series. I'd like to use that quarterly series to create an index with a certain quarter equal to 100 and all other values are divided by the data in that quarter and multiplied by 100.. For example, if I index to 1995Q1 then i divided 1994Q4 by 1995Q1, etc.

Can someone tell em the easiest way to program that, please?

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

Re: Creating an index

Postby EViews Gareth » Mon Mar 23, 2015 10:57 am

Code: Select all

series idx = x/@elem(x, "1995q1")*100

miorinnovo
Posts: 199
Joined: Sun Mar 01, 2015 5:01 pm

Re: Creating an index

Postby miorinnovo » Mon Mar 23, 2015 11:04 am

Thank you again.

How can I repay you for all your help?

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

Re: Creating an index

Postby EViews Gareth » Mon Mar 23, 2015 11:27 am

Send cupcakes.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests