Here is the code I am using but can't get summary table to show. I don't think I am using xaxistable correctly: data demog; set ref.demog_derived; data demog1; set demog; rename gendertyp=Sex; rename demogageyears=Age; run; data demog2; set demog1; sex = 'A'; output; set demog1; output; run; proc sort data=demog2; by sex; run; proc summary data=demog1; class sex ; var age; output out=work.summary mean= median= qrange=/autoname; run; data demog3; merge demog2 summary; by sex; run; proc sgplot data=demog2; vbox age / group= sex; xaxistable age sex; run; here is the result: I tried to change sex = 'A' to sex = 'Overall' to show blue graph as Overall but I get O only! and not sure what those 8 are at the top of the graph...perhaps outliers. I found another codes below that I applied to a different data set. This is exactly what I need the data to be presented except the overall graph and overall summary are missing.  ods output sgplot=sgplotdata; proc summary data=auditc nway qntldef=5; class siteabbrev; var auditc_tot; output out=summary(drop=_type_ _freq_) n=N mean=Mean median=Median q1=Q1 q3=Q3 std=STD / noinherit; run; proc sort data=auditc out=auditc1; by siteabbrev; run; data auditc2; merge auditc1 summary; by siteabbrev; run; title; ods path(prepend) work.templat(update); proc template; define statgraph sgdesign; dynamic x value ; begingraph; entrytitle halign=center 'Auditc total by Sites'; /* entryfootnote halign=left 'Type in your footnote...';*/ layout lattice / rowdatarange=data columndatarange=data rowgutter=30 columngutter=30; layout overlay / xaxisopts=( discreteopts=( tickvaluefitpolicy=splitrotate)); innerMargin / align=top; blockplot x=x block=n /display=(values label outline) valuehalign=center labelattrs=graphdatatext valueattrs=graphdatatext; blockplot x=x block=std /display=(values label outline) valuehalign=center labelattrs=graphdatatext valueattrs=graphdatatext; blockplot x=x block=mean /display=(values label outline) valuehalign=center labelattrs=graphdatatext valueattrs=graphdatatext; blockplot x=x block=median /display=(values label outline) valuehalign=center labelattrs=graphdatatext valueattrs=graphdatatext; blockplot x=x block=q1 /display=(values label outline) valuehalign=center labelattrs=graphdatatext valueattrs=graphdatatext; blockplot x=x block=q3 /display=(values label outline) valuehalign=center labelattrs=graphdatatext valueattrs=graphdatatext; endInnerMargin; boxplot y=value x=x; endlayout; endlayout; endgraph; end; run; proc sgrender data=auditc2 template=sgdesign; dynamic value="AUDITC_TOT" x="'SITEABBREV'n" ; run;   result: ... View more

Hi Peter, Thank you for quick response. Since I am fairly new to SAS, will xaxistable give me the overall graph followed by breakdown of age by each gender? I ran the code you shared and now I only get the box plot for Age and no breakdown.    Thank you,   Helal ... View more

If I understood correctly, I have to have Format files in order to use  vformat and cntlout but there no format files. The macro has helped though except it produces observations as well that I don't need and I am not savvy to change the macro and get remove the observation piece. Anyway, thank you for sharing the macro with me. ... View more

Hi Reeza, I am still struggling to get values or value labels off my SAS data sets. Using your suggestion for a single variable in the data set will give me the followings. First here is the code:   Proc SQL; select * from sashelp.vcolumn where libname="CENCD" and name='Anger_37_C'; Quit;   The output is attached (Figure 1). The only info I need for this variable is Column Name and Label+ value(or valuer labels). If I run a simple Frequency for this variable, I get the output (Figure 2 in the attached Excel file). So, my question is how can I get something like this: Name                         Labels                                                                              Value Anger_37_C              TBIQOL Anger: became verbally abusive?                       Always, Missing, Never, Often, Rarely, Sometimes   For all variable sin the data set. In the case of this variable, it looks like there is no actual Value Labels like 1= Always, 2=Sometimes, etc....rather it's the actual Character. I hope my question is clear.   Thank You ... View more

Thank you Reeza. ... View more