topic Re: Iterative Proportional Fitting other than PROC IML in SAS Procedures

Iterative Proportional Fitting other than PROC IML

patrickho0119 — Tue, 22 Jul 2014 14:05:32 GMT

Instead of using the PROC IML to conduct the Iterative Proportional Fitting, any other methods / procedures that can be dealt with.

Re: Iterative Proportional Fitting other than PROC IML

SteveDenham — Tue, 22 Jul 2014 17:09:22 GMT

Wouldn't Fisher's Exact Test do what you need in PROC FREQ? At least as far as generating a probability statement about the "extremeness" of the observed proportions? Calculating the expected proportions would be more difficult, and if that is what you need, then you will probably need to explore PROC CATMOD.

Steve Denham

Re: Iterative Proportional Fitting other than PROC IML

patrickho0119 — Wed, 23 Jul 2014 06:20:40 GMT

My situation is that the value in each cell is known, for instance, at the very beginning I got the following table:

var1	var2
var1	A1	B2	G5	Total
T1	10	30	7	47
S2	2	5	-	7
S4	-	72	9	81
U8	8	-	17	25
Total	20	107	33	160

and suppose the control total of var1 and var2 are:

var1
var1
T1	53
S2	19
S4	102
U8	50
Total	224

var2
A1	B2	G5	Total
70	57	97	224

The target is to adjust the value of each cell of the var1 x var2 with the control total.