Contingency table from a dataset

[svzplayer]

Hello,

I need help creating a contingency table from a dataset. I have a dataset in a form:

A X1 n1

A X2 n2

B X1 n3

B X2 n4 , where ni is number of observations in a group

and I need to make a contingency table from this dataset. How can I do that?

Many thanks!

[PaigeMiller]

Are you asking how to turn this into another SAS data set which is set up like a contingency table? Or are you asking for output (results window, such as html) that looks like a contingency table?

[svzplayer]

I am asking how to turn this into another SAS data set which is set up like a contingency table, sorry for ambiguity.

[Ksharp · Accepted solution]

data have;
input (a b) ($) c;
cards;
A X1 11
A X2 2
B X1 3
B X2 24 
;
run;
options missing='0' ;
proc transpose data=have out=want(drop=_:);
by a ;
id b;
var c;
run;

[svzplayer]

Thanks!