topic Extracting frequencies from contingency table in SAS Procedures

Extracting frequencies from contingency table

EMKBB — Tue, 06 Mar 2012 19:48:37 GMT

I wish to convert a of the form below

table

Color Style

A1 B1

A1 B5

A5 B2

A3 B3

A2 B1

A2 B2

A4 B1

A1 B3

A5 B1

A3 B4

A4 B4

A5 B2

A4 B2

A4 B5

A1 B2

A3 B1

A5 B1

A2 B3

A4 B2

A3 B2

A5 B3

A2 B3

A4 B3

A1 B4

A2 B5

into a contingency table and extract the frequecies into the form of table [ii] below.

Could you please direct me to any material that could help me do this?

"color" "Style" "Count"

"A1" "B1" 4

"A1" "B2" 2

"A1" "B3" 4

"A1" "B4" 1

"A1" "B5" 6

"A2" "B1" 1

"A2" "B2" 3

"A2" "B3" 2

"A2" "B4" 0

"A2" "B5" 4

"A3" "B1" 3

"A3" "B2" 3

"A3" "B3" 1

"A3" "B4" 5

Extracting frequencies from contingency table

PGStats — Tue, 06 Mar 2012 20:06:48 GMT

Tell me if you realy need those precise headers, otherwise, you could use this:

data have;
input color $ style $;
datalines;
A1          B1
A1          B5
A5          B2
A3          B3
A2          B1
A2          B2
A4          B1
A1          B3
A5          B1
A3          B4
A4          B4
A5          B2
A4          B2
A4          B5
A1          B2
A3          B1
A5          B1
A2          B3
A4          B2
A3          B2
A5          B3
A2          B3
A4          B3
A1          B4
A2          B5
;

proc sql;
create table want as
select quote(trim(color)) as qcolor label="color", quote(trim(style)) as qstyle label="Style",
count(*) as count from have
group by calculated qcolor, calculated qstyle;
select * from want;
quit;

Extracting frequencies from contingency table

EMKBB — Tue, 06 Mar 2012 20:33:44 GMT

Hi PGStats, Thanks!

Extracting frequencies from contingency table

EMKBB — Tue, 06 Mar 2012 20:56:05 GMT

Could the expected frequecies have been calculated and extracted similarly?

Extracting frequencies from contingency table

PGStats — Tue, 06 Mar 2012 21:37:12 GMT

Yes they could. But it would be a lot simpler to use proc freq to get those.

Re: Extracting frequencies from contingency table

Reeza — Tue, 06 Mar 2012 23:45:06 GMT

As PG mentioned Proc Freq is more efficient.

proc freq data=have;

tables color*style/out=want expected;

run;

Oops...The expected should be outexpect instead.

Re: Extracting frequencies from contingency table

EMKBB — Thu, 08 Mar 2012 12:02:21 GMT

Thanks, PGStats and Reeza. Is there a way of determining which combinations had zero count as part of proc freq?