You gotta need CSVALL destination, but if you have a big table, this way would be very slowly.   data FINAL; set sashelp.class; label sex='sex sfder'; run; ods _all_ close; ods csvall file='c:\temp\a\output.csv'; title; ods text='Consent'; proc report data=final nowd ; define _all_/display; run; ods csvall close;   ... View more

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

Go into the macro program (.sas). Comment out the proc datasets at the end and then you'll get datasets in your work library. Look through those and one should have what you need and you can filter the results as desired. Otherwise if you need more help you'll have to provide more details. Specifically an more detailed example of what you have and what you want. I'm working on guesses, which is usually right, but also very easy to be wrong, especially since your terminology is non-standard. ... View more