I have a dataset of people who have lost their employment during the period 2019-2021.
I have variables about the year of dismissal (Year_Dismissal) and various individual characteristics: Sex, Age, Education. Moreover, a dummy variable concerning whether or not each individual has found a new job within 6 months from dismissal is also available (Found_New_Job).
I would like to build a table in which, by year, for each individual characteristic is reported the percentage of fired people who have found a new job within 6 months (Fonund_New_Job)
Roughly, the table should look like this:
2019 | 2020 | 2021 | |
Sex | |||
Male | 40% | 41% | 50% |
Female | 30% | 35% | 40% |
Age | |||
15-34 | 45% | 40% | 37% |
35-54 | 36% | 46% | 60% |
>=50 | 40% | 41% | 50% |
Education | |||
No formal education | 45% | 40% | 37% |
Primary | 36% | 46% | 60% |
Secondary | 40% | 41% | 50% |
Tertiary | 30% | 35% | 40% |
I would really appreciate any suggestion.
Thank you
0 Response to Creating, appending and exporting tables
Post a Comment