Counting across variables with same stub

[Sarah Haynes]

Hello,

I am certain that this is an easy problem but I can't seem to find anything on the forum. I have a wide dataset with 180 day variables labeled day1, day2, day3, day4, etc. Each variable can take on a value of 0 through 7. I am interested in a count of how many times this day variable takes on the value of 1. I would like to do this for various intervals though, not for all 180 days. For example, I'd like to be able to see how many 1's there are for each individual from day1 through day5, then day6 through day15, etc. I've included a dataex example below.

Any help is much appreciated,

Sarah

* Example generated by -dataex-. To install: ssc install dataex
clear
input float idn double(day1 day2 day3 day4 day5 day6 day7 day8 day9 day10 day11 day12 day13 day14 day15)
 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
 2 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0
 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3
 4 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1
 5 0 0 0 0 0 2 2 2 2 2 2 2 2 2 2
 6 0 0 0 0 1 1 1 2 2 2 0 2 2 2 2
 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2
 8 0 0 0 0 1 1 1 1 1 1 0 0 0 0 0
 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
12 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1
13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1
16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
18 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
19 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
20 0 0 0 0 0 0 1 1 1 1 1 0 0 1 0
21 0 0 2 2 2 0 0 0 0 0 0 0 0 0 0
22 0 0 0 0 0 0 0 0 0 2 2 2 2 2 2
23 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1
25 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
26 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1
27 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
28 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
29 1 0 0 0 0 2 2 2 2 0 0 0 0 0 0
 . . . . . . . . . . . . . . . .
30 0 0 6 0 0 0 0 0 0 0 1 0 0 0 0
31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
32 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
33 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
34 0 0 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
36 0 0 0 1 1 1 1 1 0 1 1 1 1 1 1
37 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
38 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
39 0 0 0 1 0 0 0 0 0 0 1 1 0 0 0
40 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0
41 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1
42 0 0 0 0 0 0 0 0 2 2 2 2 2 2 2
43 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
44 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1
45 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1
46 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
47 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1
48 0 0 0 1 1 1 0 1 1 1 1 1 1 1 1
49 0 0 0 0 0 0 1 1 1 0 0 1 0 0 1
50 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0
51 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
52 2 2 2 2 2 2 2 2 0 0 0 0 0 0 0
53 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0
54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
55 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
56 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1
57 0 0 0 0 0 0 0 1 0 1 1 1 1 1 1
58 0 0 0 0 0 0 0 0 0 1 0 1 0 1 1
59 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1
60 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
61 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
62 0 0 0 0 0 0 1 1 1 2 2 2 1 0 0
63 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
64 0 0 6 0 0 0 0 0 2 2 2 2 0 0 0
65 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1
66 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1
67 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
68 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1
69 0 0 0 0 0 0 0 0 1 0 0 1 1 1 1
70 0 0 0 0 0 0 0 0 0 6 0 0 0 0 0
71 0 0 0 0 0 0 0 0 1 0 1 1 0 0 1
 . . . . . . . . . . . . . . . .
 . . . . . . . . . . . . . . . .
 . . . . . . . . . . . . . . . .
72 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
73 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1
74 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
75 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
76 0 0 0 0 0 0 0 1 1 1 1 0 0 0 0
77 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
78 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
79 0 0 1 1 1 1 1 1 1 1 2 2 7 0 0
80 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0
81 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
82 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
83 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1
84 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1
85 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1
86 0 0 0 2 2 2 2 2 1 0 0 0 0 1 1
87 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
88 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1
89 0 0 0 0 0 0 0 0 1 1 1 1 1 0 1
90 0 1 1 1 1 1 1 1 1 1 0 0 0 0 0
91 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
92 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1
93 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
94 0 0 0 0 0 0 0 0 1 0 1 1 1 0 1
 . . . . . . . . . . . . . . . .
95 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
end

[Rich Goldstein]

try these:

egen byte d1_5=anycount(day1-day5), val(1)
egen byte d6_15=anycount(day6-day15, val(1)

obviously you should substitute the names you want fo the names I put in after "byte"

[Nick Cox]

I'll add the standard advice that most problems with data of this kind are easier with a long layout.

[Sarah Haynes]

Thanks both!