PROC FREQ - Cross Tab Table in a long format

SAS_freq_crosstab_table.sas

/*This program is used when you want multiple m*n tables and you want it summarized. In this case the one variable, SEX is in the 
KEEP statement, this will change depending on the variables in the code*/

ods output crosstabfreqs=summary;
proc freq data=sashelp.class;
table sex*(_all_);
run;



data long;
	length variable $32. variable_value $50.;
	set summary;
	Variable=scan(table, 2, '*');
	Variable_Value=strip(trim(vvaluex(variable)));
	presentation=catt(frequency, " (", trim(put(percent/100, percent7.1)), ")");
	keep sex variable  variable_value frequency percent presentation;
	label variable='Variable' variable_value='Variable Value';
run;