How to use Pivottable functions from excel in eviews

[eyt]

Hi all,

I would like to create a series based on two other series. e.g. the two series is similar to this:

SeriesA SeriesB
1 A
2 B
3 C
4 D
2 E
2 F
2 G
3 H
3 I


The new series I would like is one that counts how many observations in SeriesB corresponding to the observations in SeriesA. it would look like this:
SeriesNEW
1
4
3
1
4
4
4
3
3

In excel, I would use the pivot table, and place series A on the rows, and series B on the values. And the counts would be generated. But since I am using an extremely large dataset, I am unable to use excel and import it into eviews.

I hope its clear, thanks in advance!

[EViews Gareth]

I think you want the @countsby function.

[eyt]

Hi, thanks for the reply.

But I am not familiar with Eviews, can you please let me know how to implement the function @countsby to create the series? Or is there information on it somewhere?

Thanks!

[startz]

@countsby is a secret function. If you enter it in the index or the search field of the Help system nothing shows up.

[EViews Glenn]

It's listed under "by-group statistics".

[startz]

Not on my copy it's not. (I know, I have some option set wrong.)

Capture.PNG (23.25 KiB) Viewed 5380 times

[eyt]

I currently have eviews 8, I tried looking up the function but I cannot find it in the help files or online.

Can someone please let me know how to structure the commands for the desired series? :?

[EViews Gareth]

I guess it is @obsby rather than @countsby