tw3xls

The program allows to nicely export three-way and four-way tables into xls or xlsx.

安装：

ssc install tw3xls 公卫论坛

范例：

公卫人

tw3xls rowvar supercolumnvar columnvar using example1, (options) 公卫百科

说明：

公卫人

The program itself was inspired by -tab2xl- and -tab2xl2- . 公卫家园

Several words of notice:

1) -tw3xls- works with both numeric and string values;

2) When you use encoded variables, the output will contain numeric codes. If you want to see the labels in the output, make sure an encoded variable is decoded and contains string values;

公卫百科

3) A three-way table consists of the following parts: rows, columns and supercolumns;

公卫百科

4) A four-way table is defined as a set of three-way tables. For example. if there are four unique values in the by-variable, you will get four similar three-way tables in Excel, each one representing its own group; 公卫论坛

5) Performance degrades significantly when there is a large number of groups in the by-variable.

公卫人

作者： 公卫论坛

Andrey Ampilogov