Hi

I have done a quantitative content analysis on a number of articles and have coded them binary on a range of variables. I also coded what week number the article was published.

I now need to run analysis with the week number as the aggregate. Therefore i need to combine my observations so that i have one observation for each week with a count of positive binaries from all the other variables. How can one do that?

My current data looks like this:
week var1 var2 var3 var4
1 1 0 0 1
1 1 1 1 0
2 0 0 1 1
2 1 0 1 0
2 0 1 1 0
3 1 1 1 1
3 0 0 0 1
I want it to be like:
week var1 var2 var3 var4
1 2 1 1 1
2 1 1 3 1
3 1 1 1 2
I hope it makes sense and that somebody can help me :-)

Aske