topic Re: PROC FREQ How to generate a fixed size crosstab in SAS Programming

PROC FREQ How to generate a fixed size crosstab

RorschachYoung — Fri, 29 Jan 2021 04:14:52 GMT

data a;

input x y;

datalines;

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 — Mon, 01 Feb 2021 23:23:52 GMT

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 — Thu, 18 Feb 2021 02:02:22 GMT

thanks a lot