how to calculte the number of different obs in a series

[xubin1988]

for example, i have a series: {1,1,2,3,4,5,6,6}
the observation number of this series is 8, which I think can be retrieved by the function of @obs
but the number of different variables in this series is 6

how to achieve the second purpose by the functions in eview?

Thanks in advance !!!

[EViews Gareth]

Open the series, and then choose View->One Way Tabulation.

[xubin1988]

Open the series, and then choose View->One Way Tabulation.

hey thanks for answering!
how one way tabulation can cont the different numbers in a series?
and i have so many series to do this manipulation
so do you know how to run this count by evews functions?

[EViews Gareth]

There is no function that will return the number of unique values in a series. You can easily see the number of unique values with a one-way tabulation, though.

To perform one-way tabulation in a program, you can use series.freq

[xubin1988]

There is no function that will return the number of unique values in a series. You can easily see the number of unique values with a one-way tabulation, though.

To perform one-way tabulation in a program, you can use series.freq

hi,

i see how to use one way tabulation to count unique number now

can you tell me how to conduct such operation by functions?

I think there would be a function if i can use it by clicking mouse

[xubin1988]

There is no function that will return the number of unique values in a series. You can easily see the number of unique values with a one-way tabulation, though.

To perform one-way tabulation in a program, you can use series.freq

or can you figure out a code to solve my problem?

thanks in advance!!

[EViews Gareth]

To perform one-way tabulation in a program, you can use series.freq

[CharlieEVIEWS]

Lot of views on this thread so I thought I'd post:

Code: Select all

freeze(seriesfreq) myseries.freq scalar numberunique = @val(@mid(seriesfreq(5,1),22))

Should do the trick. Works for alphas too.

[EViews Gareth]

Since this thread was originally posted, the @uniquevals function was added to EViews. Much easier to use that programmatically.

[CharlieEVIEWS]

i need there to be a ::facepalm:: smilie. still might come in useful for somebody one day though.