Hi,

My name is Jiwan. I'm currently working on Korean Household Income and Expenditure Survey, to see the effect of COVID-19 on households' changes in their income and public transfer by comparing 2019 vs. 2020 and 1Q vs. 2Q, with subgroups of income quantile and employment status.
It is longitudinal data, but not panel data, with long-form.
I would like to see the descriptive statistics of how their income has changed, calculating the percentage changes.

First, I would like to make a table for the percentage changes in income for 2020-1Q(compared with 2019-1Q) and 2020-2Q(compared with 2019-2Q) separately, with a subgroup of 20-quantile. I used this code:

Code:
bys year qt: sum pincome if q20_all==1
bys year qt: sum pincome if q20_all==2
bys year qt: sum pincome if q20_all==3
bys year qt: sum pincome if q20_all==4
bys year qt: sum pincome if q20_all==5
but I need to do extra work in excel to calculate the percentage changes.
I'm wondering if there is a more effective way to get what I want within Stata.

Second, I would like to examine how the stimulus payment was effective to compensate for the income loss.
So I want to calculate Compensation=benefit/income loss.

Then I need to calculate the decrease in income and the increase in social benefit, each amount compared to the previous year, 2019.
That is, I want to calculate: [Social benefit(2020)-Social benefit(2019)]/[Income(2020)-Income(2019)]
Also, I'd like to see how this figures differ by the subgroups: employment status and 20-quantile.

Code:
bys year q20_all: sum pincome if empstat1==1
bys year q20_all: sum benefit if empstat1==1

bys year q20_all: sum pincome if empstat1==2
bys year q20_all: sum benefit if empstat1==2

bys year q20_all: sum pincome if empstat1==3
bys year q20_all: sum benefit if empstat1==3

bys year q20_all: sum pincome if empstat1==4
bys year q20_all: sum benefit if empstat1==4

bys year q20_all: sum pincome if empstat1==5
bys year q20_all: sum benefit if empstat1==5
Again, I wonder if there exists a way to get this number without doing extra works in Excel.

Thank you so much for your time and consideration.
I'm looking forward to hearing from anyone who would kindly help me!

Jiwan