Creating tables using results from different datasets

[Mansha Mahajan]

Hi all,

I'm working on creating descriptive tables for my analysis and I'm fairly new to working with multiple datasets. I'm working with datasets from 6 different countries and want to create a single summary table for one variable (let's call it median salary of worker) with variable stats in columns and countries as rows. My issue here is that since I'm working with 6 different datasets and I don't exactly know how I can store the results from each dataset and then create a single table with the output (median salary). I know I can merge the 6 datasets and then create my tables but I'm wondering if there's an easier way to store my results and then use -esttab-. Or if there's a way to combine my results from each dataset and output them in a table.

Thank you for any suggestions here!

Best,
Mansha

[Attaullah Shah]

You can try asdoc, which is fairly easy to use and creates nicely formatted tables.

ssc install asdoc

To get started, you can watch this quick YouTube video. For a more complex work, like the one you have mentioned, you can use asdocx (premium version, available for a fee that is not more than a cup of coffee), that is extremely flexible in creating customized tables and storing statistics from different commands. See this YouTube video where I use asdocx to create a table bit by bit. asdocx has also several other powerful features, which you can explore here.

[Mansha Mahajan]

Professor Shah, this was very helpful. I could at least get started with my tables for descriptive stats for each dataset. I do still have to do a bit of copy pasting in word but I guess there isn't an easy way to store results from different datasets and output them in one table (or I haven't figured it out yet) in Stata. -asdoc- is definitely easier to use and replicate tables. Thanks a lot!