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?
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;
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.