Table/matrix of turnover between deciles

[Martijn Kreft]

Hi everyone,

I have panel data for stocks and I assigned the stocks to deciles. I want to know how often stocks changes deciles and how often they change to decile x in order to check turnover. I created a lead variable which I would like to compare to the original variable in a correlation matrix. I feel like this should be easily possible, but somehow I can't seem to figure out how to put two categorical variables in such a matrix. Do you have any suggestions/solutions?

Thanks!

[Martijn Kreft]

Found it!
Create a lead variable and tabulate lead and original (options nofreq and row)