EViews.com

Hey,

I have a panel data set which contains N cross-sections and T periods.

I would like to save the maximum value of a each cross section of a certain series and save the maximum value including the identifier as well as the date.

I thought of something like this: However, this will assign the maximum value to all entries (i.e. for all N and T the same value).

I think it would help to use the @max command in the sampling environment, but I dont know how to apply it in this case.

Best

Honestly, it doesnt really help.

I would be happy to further explain my issue if it has not been clear so far.I kindly ask you to tell me what remains to be clarified in that case

Best

Just use @maxsby with the cross-section id series as your by-variable

Suppose I have a series called "maxvalue". This series contains different values for each date for each cross-section. The cross sections are identified by the series "ident". I need to access the maximum value for each cross section of the series "maxvalue". The maximum value of "maxvalue" might be at different points in time for each cross section.

If if use something like the same value (indeed the maximum value) for a cross sections is assigned to all points in time. I require it to be the maximum value at the point in time when it is maximized and zero or NA otherwise.

Still havent figured out how to get there.

Gareth, If I'm interpreting correctly, I think the original question was a bit more complicated, as the poster wanted the historical max at a each point in time. (If that interpretation is correct, the answer is only a tiny bit more complicated than your answer -- if I'm wrong, you all can just ignore me).

Suppose we have a dated panel structured workfile with the series F of interest.

We are going to write a recursion to identify the historical maximum for the cross-section at a given point in time. First, we seed the recursion. Next, for the remaining periods we compute the historical maximum by comparing the current value to the lagged historical maximum. Note that in since this is a dated panel workfile, the by-cross-section part of the calculation is handled naturally via the sample and recursion.

Lastly, we do the recoding to NAs.

And of course, I forgot that we have a @cummax function which simplifies things even further as the whole first part of my post can be done in a single line.

Thank you, Gareth's suggestions does the trick.