logical count

[londonphd]

Hi,

I want to count the number of observations that are greater than say a 100x4 matrix. The code will be used in a loop where the rows/columns of the matrix will be indexed i.e.loop goes over each element of the matrix. In each run of the loop, I want to count elements greater than 1 per row.
I tried the following code, it did not help.

Code: Select all

mat1(!i,1) = @sum(matname(!i,!j)>1)

Thanks

[EViews Gareth]

I don't follow

[londonphd]

I don't follow

Hello Gareth,

I have data that is stored in a 100x5 matrix. I want to count how many elements per row are greater than 1.

THanks.

[EViews Gareth]

Brute force:

Code: Select all

vector(100) count for !i=1 to 100 !count = 0 for !j=1 to 5 if x(!i,!j)>1 then !count=!count+1 endif next count(!i) = !count next

[londonphd]

Brute force:

Code: Select all

vector(100) count for !i=1 to 100 !count = 0 for !j=1 to 5 if x(!i,!j)>1 then !count=!count+1 endif next count(!i) = !count next

Wow, thanks. But this probably makes my already inefficient code a more inefficient one :)

[EViews Gareth]

If it is a one-off operation, then it probably takes 100th second, and the most efficient could be done in 1000th second. No big deal.

If you're doing it 1000 times, or as part of an optimization procedure, then yeah, you might want to think of something more efficient.

[londonphd]

If it is a one-off operation, then it probably takes 100th second, and the most efficient could be done in 1000th second. No big deal.

If you're doing it 1000 times, or as part of an optimization procedure, then yeah, you might want to think of something more efficient.

I cannot think of anything else. Will use it and have to just wait a few seconds I guess. Big Thank you!

[EViews Glenn]

Code: Select all

matrix(10000, 5) a nrnd(a) matrix(10000, 5) b b = 1 vector count count(1) = @sum(@egt(a, 1))

Not certain, but this should be faster.

[EViews Gareth]

Couldn't remember if @egt was in EV10 only :D