proc-freq-post

data mytable;
	
    input id= name=$12. balance= state=$2.; 

DATALINES;
id=1 name=alice balance=5.12 state=NE
id=2 name=bob  balance=12.31 state=SC
id=3 name=charlie balance=45.14 state=NY
id=4 name=daniel balance=32.78 state=
id=5 name=alice balance=20.23 state=WA
id=6 name=bob balance=70.89 state=NM
id=7 name=gabe balance=29.67 state=NM
id=8 name=charlie balance=55.66 state=CA
id=9 name=ivan balance= state=
;
run;


proc freq data=mytable; 
	tables state;
run;

proc freq data=mytable; 
	tables state / missing;
run;

ods graphics on;
proc freq data=mytable; 
	tables state / plots=freqplot();
run;

proc format;
	value balance_bins
		0       = "Exactly 0"
		0 -< 10 = "Up to US$ 10"
		10 -< 20 = "From US$ 10 to US$ 20"
		20 -< 30 = "From US$ 20 to US$ 30"
		30 -< 40 = "From US$ 30 to US$ 40"
		40 -< 50 = "From US$ 40 to US$ 50"
		50 - high = "Above US$ 50"
		. = "No data"
		other = "???";
run;

ods graphics on;
proc freq data=mytable;
	tables balance/ missing plots=freqplot;
	format balance balance_bins.;
run;

ods graphics on;
proc freq data=mytable;
tables state*name / plots=freqplot(groupby=row twoway=stacked);
run;

ods graphics on;
proc freq data=mytable;
tables state*balance / plots=freqplot(groupby=row twoway=stacked);
format balance balance_bins.;
run;