DATA Step, Macro, Functions and more

rearranging data in sas

Reply
Contributor
Posts: 33

rearranging data in sas

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.

Super User
Super User
Posts: 6,502

rearranging data in sas

proc freq ;

  tables response*category / norow nopercent ;

run;

Ask a Question
Discussion stats
  • 1 reply
  • 110 views
  • 0 likes
  • 2 in conversation