st: sum of count using a loop

[Keniajin Wambui <kiangati@gmail.com>]

I have a data set with a unique pid and a list of 32 variables with
the same suffix i.e maize_source, peas_source, sukuma_source,
cabbage_source.....
All the 32 variables have  option 1,2,3 or 4. I want to do a sum of
all the counts of each option for across all the variables using stata
12 on windows 7
i.e
option    total
1           4000
2             568
3          1200
4          14000

I am trying

foreach var of varlist  maize_source - peas_source {
count if `var'==1
    replace total=_N+_n if `var'==1
countif `var'==1
        }
but its giving a count with a wrong total

I will appreciate the support
-- 
Mega Six Solutions
Web Designer and Research Consultant
Kennedy Mwai
25475211786
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/