Dear stata users,

I am assessing the effects of state dependence i.e. employment at time t-1 and migration on employment at time t. My panel dataset which consists of information on employment and migration looks like the one below. Could you assist on stata command that would give descriptive statistics for the following:

XX% of those who were employed at t - 1 and were also employed at time t
XX% of previously employed (i.e. at time t-1) who did not migrate and were unemployed at time t
hhid Year employment migration
0231 1999 1 1
0231 2000 0 0
0548 1999 0 1
0548 2000 1 1
…..
Many thanks in advance.