Table of frequencies

[Inaamul Haq]

I am trying to make a table of frequencies from the data.

* Example generated by -dataex-. To install: ssc install dataex
clear
input float id byte(ag du pg mal rut gp egb hh eso fg hu cg gd pgp fgh eag)
 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
 2 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0
 3 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
 7 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
 8 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0
 9 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
10 1 1 0 0 1 0 1 0 0 0 0 0 0 0 0 1
11 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
13 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0
14 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
17 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
18 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0
19 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0
20 0 1 0 0 1 0 1 0 0 0 0 0 0 0 0 0
21 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
26 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
27 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
28 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
29 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1
30 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
32 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0
33 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
34 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
35 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
36 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1
37 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
38 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0
39 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
40 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0
41 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
42 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
43 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
45 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
46 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
47 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
48 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
49 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
50 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
end

Specifically, I want to make one table that shows the frequency of 1 for each of the variables in the dataset. Like this below:
varname freqof1
ag 126
du 17
pg 25
mal 7
rut 19
gp 7
egb 86
hh 14
eso 4
fg 5
hu 10
cg 21
gd 7
pgp 2
fgh 1
eag 21

[Nick Cox]

Search this forum for mentions of tabm, a command in the tab_chi package on SSC,

[Inaamul Haq]

Thank you. Found what I was looking for.

tabm

worked nicely.