Hello, I am trying to create an easy-to-read output table with 42 variables (rows) and their distribution within gender classes. I could use proc freq as follow: proc freq data=mydata;
table (anm_diabete anm_scompenso_cardiaco anm_pacemaker anm_bpco ... )*ang_sex/ norow nopercent;
run; but I would like to unify the results in a single table. I tryed to use proc tabulate with this code: proc tabulate data=mydata;
class anm_diabete anm_scompenso_cardiaco anm_pacemaker anm_bpco ... ang_sex;
table (anm_diabete anm_scompenso_cardiaco anm_pacemaker anm_bpco ...), ang_sex*(n='N'*f=8.0 pctn<anm_diabete anm_scompenso_cardiaco anm_pacemaker anm_bpco ...>='%'*f=8.1) / box=' ';
run; This procedure works with few variables, but with the entire set of variables (42 variables), frequencies are totally different. Here is the output with only 4 variables (and correct frequencies/percentages): Here is the output with all 42 variables inserted in the proc tabulate (only first 8 variables shown): Any ideas about how to correctly use proc tabulate or any macro to unified results from proc freq? Thanks in advance!
... View more