How to show a crosstab of transitions with panel data?

Hi everyone,

I'm using the plm() package to run a fixed effects regression model for repeated observations during 5 years. I am testing the impact of being eligible to a social transfer program on hours worked. However, I have a suspicion that few of the people in my sample move from being eligible to not eligible over these 5 years. I would like to know how many of them have moved from 0 to 1 since my variable is a dummy one. The expected outcome is like this :

xxtrans Like Stata's command xttrans. For instance here, each year, some 80% of the msp 0 persons in the data remained msp 0 in the next year; the remaining 20% became msp 1.

Does anyone have a solution in R? Thank you so much!


To help us help you, could you please prepare a reproducible example (reprex) illustrating your issue? Please have a look at this guide, to see how to create one:

Short Version

You can share your data in a forum friendly way by passing the data to share to the dput() function.
If your data is too large you can use standard methods to reduce it before sending to dput().
When you come to share the dput() text that represents your data, please be sure to format your post with triple backticks on the line before your code begins to format it appropriately.

( example_df <- structure(list(Sepal.Length = c(5.1, 4.9, 4.7, 4.6, 5, 5.4, 4.6, 
5, 4.4, 4.9), Sepal.Width = c(3.5, 3, 3.2, 3.1, 3.6, 3.9, 3.4, 
3.4, 2.9, 3.1), Petal.Length = c(1.4, 1.4, 1.3, 1.5, 1.4, 1.7, 
1.4, 1.5, 1.4, 1.5), Petal.Width = c(0.2, 0.2, 0.2, 0.2, 0.2, 
0.4, 0.3, 0.2, 0.2, 0.1), Species = structure(c(1L, 1L, 1L, 1L, 
1L, 1L, 1L, 1L, 1L, 1L), .Label = c("setosa", "versicolor", "virginica"
), class = "factor")), row.names = c(NA, -10L), class = c("tbl_df", 
"tbl", "data.frame")))

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.