unbalanced panel

[mark]

Eviews 7.1
I working with unbalanced panel data set (870, 3705)
How can I extract the maximum value for each project (870) and dump it into a series
tried:

series try=@maxby(projectnum, @crossid)

Second
I have a decriptive string variable which vaires within each project and across project - I'm sampling the string using @instr(xxxxx, "yyyy")>0
Can I add booleans within the command as so

@instr(xxxxx, "yyyy" or "zzzz" and "oooo")>0

thanks

[EViews Gareth]

did the @maxby not work for you?

In answer to the second part, yes:

Code: Select all

smpl if @instr(xxxxx, "yyyy")>0 or @instr(xxxxx,"zzzz")>0 and @instr(xxxxx,"oooo")>0

or something along those lines.

[mark]

get an error when I try this

genr try=@maxby(qty,@X)

I want put the the maximum value from each "X" section in a new series called "try". The number of observations vary by "X"
Works if I just want the max of "qty" but when I add by the cross section identifier (in this case @X) I get this error

@maxby is not a Genr or series expression function

[EViews Gareth]

genr = @maxsby(qty,@crossid)

(note that it is @maxSby, and note that you need to keep it as "@crossid")