topic Re: Contingency table from a dataset in SAS Procedures

Contingency table from a dataset

svzplayer — Mon, 25 May 2020 09:50:48 GMT

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!

Re: Contingency table from a dataset

PaigeMiller — Mon, 25 May 2020 09:55:42 GMT

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?

Re: Contingency table from a dataset

svzplayer — Mon, 25 May 2020 09:56:14 GMT

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

Re: Contingency table from a dataset

Ksharp — Mon, 25 May 2020 10:31:24 GMT

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;

Re: Contingency table from a dataset

svzplayer — Mon, 25 May 2020 10:41:28 GMT

Thanks!