Stata Pivot Table. The default is that missing entries be left blank. Here is the general form of the table command.
Also see r tabstat for yet another alternative. Excel is used to analyze data of different types including categorical data. Scolumn specifies that a supercolumn be added to the table reflecting the total across supercolumns.
Date a b c grand total 1 1 93 2 0 0 2 1 2 93 1 3 4 8 1 3.
To explore the data by groups you can sort the columns for the variables you want for example gender or major or country etc and obtain descriptive statistics by selecting only the range of values that cover particular group. Table row variable column variable super column variable by super row var list contents freq before we begin let s load the hsbdemo dataset and create an additional categorical variable read level. Missing specifies that missing statistics be shown in the table as periods stata s missing value indicator. Exploring data using pivot tables.
