@Stdev and DB

[tchaithonov]

Hi Guys, how are you doing?

I am trying to calculate the statistics of a bunch of independent variables located in the DB, and it seems to me that if I do the calculation with variables directly from the database, EViews would give me a "Syntax Error" response.

e.g.,

scalar z = @stdev(abc) ' This one is okay, but ...
scalar z = @stdev(abc::abc) ' This one would give me a syntax error
series z = @stdev(abc::abc) ' This one is okay too, but I only want 1 number....

Any ideas?

Tchaithonov

[EViews Gareth]

Probably just the way it is. Essentially series assignment is much more intelligent than scalar assignment, and so series assignment is able to read directly from the database, whereas the scalar isn't.