rearranging data in sas

[Nupur20]

I have a data in sas like:

Category Response

A 50% - 70%

A 0%

A 0%

A More than 70%

B More than 70%

B 1% - 49%

B 0%

B 0%

B 50% -70%

I want my result data to look like:

Response A B

0% 2 (50%) 2 (40%)

1% -49% 0(0%) 1 (20%)

50%- 70% 1 (25%) 1 (20%)

More than 70% 1 (25%) 1 (20%)

Explanation of result data:

There are two categories A (=4)and B (=5) and there are four different types of response 0%, 1% -49%, 50% -70% and more than 70%.

In category A, only two out of four responded 0%, thus result is 2 (50%). Similarly in A, on;y one out of four responded 50-70%, thus result is 1 (25%).

Same as B for each response.

I would be grateful for your time reagarding the same.

[Tom]

proc freq ;

  tables response*category / norow nopercent ;

run;