Exporting mulitway table to Excel

[Rene Geiss]

Dear forum members,

I tried really hard but could not get any satisfying results: I want to export a multiway table to Excel that consists of multiple variables and statistics. I don't mind the formatting or structure - I only want to export to Excel where I can continue editing formats, row/column arrangement, etc. So I have 7 product categories and 5 product status with 3 additional binary variables (2 of them are not mutually exclusive) for about 12 statistics (mean and SD or abs. no. and rel. no.). I attached a screenshot of the first 2 product status for the first 2 product categories for better understanding, but like mentioned, the formatting is not important. The complete Excel table is attached as well. Also, I know it's messy but the dataset is huge and categorization therefore required.

Summary Table.xlsx

It'll be very tedious work, I know. That's why I'm hoping to be directed into the right direction (not expecting any forum member to come up with the entire code). Maybe it's also worth mentioning that I'm a Stata newbie. Thanks a lot for any support and thoughts.

Best regards,
Rene

[Rene Geiss]

By the way, this is my table command:

table (result) (ProductStatus InOrOut H_present N_present) (ProductCategory) if exclude == 0, stat(count ID) stat(percent ID) stat(mean KPI1 KPI2 KPI3 KPI4 KPI5 KPI6 KPI7 KPI8 KPI9 KPI10 KPI11) stat(sd KPI1 KPI2 KPI3 KPI4 KPI5 KPI6 KPI7 KPI8 KPI9 KPI10 KPI11) nformat(%9.1f percent) nformat(%9.1f mean) nformat(%9.1f sd)

[Rene Geiss]

Studying the documentation of

putexcel

once more I realized it's a super easy command for this:

putexcel A1 = collect

The outcome is just as intendend - perfect. So, issue solved!

[Rene Geiss]

Studying the documentation of

putexcel

once more I realized it's a super easy command for this:

putexcel A1 = collect

The outcome is just as intendend - it only takes a very long time. So, issue solved!