summary frequency table of 3 categorical varaibles

[Ronein]

Hello

I want to create a summary frequency table .

The table will include 3  categorical variables.

In the summary table there is interaction between two categorical variables

Please see attach the table (how should it look like)

Let's say that there are 3   categorical :Z1,Z2,Z3

Can anyone show by proc tabulate and proc report how to produce this summary report?

[mkeintz]

I'd suggest you study this example using data from sashelp.cars:

data have;
  set sashelp.cars;
  where make in ('Acura','Audi','Chevrolet');
run;

proc tabulate data=have;
  class make type origin;
  tables make * type all='TOTAL'
         ,
		 (origin all='TOTAL')*N=' '*f=8.0;
run;

[PaigeMiller]

Some of us will not (or cannot) download Microsoft Office attachments, as this is a security risk.

Please show the desired output via screen capture, included in your reply via clicking on the Photos icon.