Collect: How to combine percent statistics from table with data collected from sum

[Shin Jiraphongtrakul]

Currently I have the table below by using collect, table and appending them together:

collect: table (educ_4concat) (labforce sex), statistic(percent, across(labforce)) nototals style(table-1)

collect: table (age_4concat) (labforce sex), statistic(percent, across(labforce)) nototals append

collect: table (race_3concat) (labforce sex), statistic(percent, across(labforce)) nototals append


collect layout (educ_4concat age_4concat race_3concat) (labforce[2]#sex)

However, I would like to add mean of annual hours work as a new column after collecting them:

gen annualwork = uhrsworkt * 52
bysort educ_4concat: summarize annualwork
collect: bysort educ_4concat: summarize annualwork
bysort age_4concat: summarize annualwork
collect: bysort age_4concat: summarize annualwork
bysort race_3concat: summarize annualwork
collect: bysort race_3concat: summarize annualwork

How can I use collect to add the column of mean annual hours work to the existing table?

Thank you for your answers in advance!

[Nick Barton]

Perhaps something along the lines of this will work. First add the means to the collection, which you can subsequently add to a layout.

collect: table (educ_4concat) (), stat(mean annualwork) append
collect: table (age_4concat) (), stat(mean annualwork) append
collect: table (race3_concat) (), stat(mean annualwork) append

collect layout (educ_4concat age_4concat race3_concat) (labforce[2]#sex result[mean])

Without the data, I cannot test this for you.

[Shin Jiraphongtrakul]

Thank you, sorry for the late reply. I was able to use this and get my desired result.