Dear all,

I have a dataset with multiple variables on the firm and investor level over multiple years. I need the data for a firm to have information only once for each year.

For it, I used the following code: collapse (max)PRISignatoryStatus, by(ISIN Year) - however, it deletes all other variables. I need it to indeed "filter" by ISIN and Year but for all variables in the dataset.

Could you please let me know what I am doing wrong?

Thank you very much in advance.