topic Re: summary frequency table of 3 categorical varaibles in SAS Programming

summary frequency table of 3 categorical varaibles

Ronein — Mon, 21 Oct 2019 19:49:36 GMT

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?

Re: summary frequency table of 3 categorical varaibles

mkeintz — Mon, 21 Oct 2019 19:59:34 GMT

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;

Re: summary frequency table of 3 categorical varaibles

PaigeMiller — Mon, 21 Oct 2019 20:09:41 GMT

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.