My data looks something like this (1st row are the variable names):
group---var1---var2---var3---var4......
group1--no----yes----yes---no
group2--yes--no-----yes----yes
I want to do something like a frequency count (like proc freq, but transposed--frequencies and all possible response only) where the name of the variable is on the left side and there are three columns (yes,no,blank) with the count for each response to the right of the variable name.
The table examples you provided will list the variable name (on the 1st row) along the left as well as the possible responses in the 2nd(blank), 3rd(no) and 4th(yes) rows.
Once I understand how to do this "one-way" table, I want to add the "group" to the top for the "two-way" dimension.
------|--Group1-------|-----|--Group2-------|
----- |--no--| |--yes--|-----|--no--| |--yes--|
var1
var2
var3
var4
... View more