Dear All: My portion of my data set is as follows:

Date ID Var Mar1 A 1 Mar1 A 3 Mar1 A 10 Mar1 A 4 Mar1 A 5 Mar1 B 4 Mar1 B 5 Mar1 B 7 Mar2 A 2 Mar2 A 0 Mar2 A 3 Mar2 A 4 Mar2 A 1 Mar2 A 1 Mar2 B 9 Mar2 B 7 Mar2 B 6 Mar2 B 8

I want three categories 0-1 Category 1 2-5 Category 2 6-10 Category 3

My Table should look like

A PercentA B PercentB Mar1 0-1 1 20% 0 0% 2-5 3 60% 2 67% 6-10 1 20% 1 33% Mar2 0-1 3 60% 0 0% 2-5 2 40% 4 100% 6-10 0 0% 0 0%

Please help