PROC FREQ How to generate a fixed size crosstab

[RorschachYoung]

data a;

input x y;

datalines;

1 2

1 2

1 2

1 2

;

run;

proc freq data=a;

table x*y/out=out outpct;

run;

This procedure will generate a 1*1 crosstab ;

If the range of x is 1-4 and the range of y is 1-4,how can i generate a fixed 4*4 table counting the zero counts?

Thanks~~~

[ChrisNZ · Accepted solution]

One way:

You have to tell the procedure that these values exist.

=> Add the corresponding records to the data,with a value of zero.

You then have to tell the procedure that these values must be used.

=> Add a WEIGHT variable and use the WEIGHT statement with the ZEROS option..

[RorschachYoung]

thanks a lot