ODS region

eramirez — Fri, 22 Jan 2021 15:47:00 GMT

Hello

I outputted results from proc tabulate and sgplot to a pdf file. I used ODS region to place the table and bar chart next to each other on one page. Everything looks good except for the label for ALL (tables (ALL='Total'...), instead of total, it's using a label for another variable? When I don't use ODS region, it resolves that issue. Not sure what I'm missing or if there is a better way to output the table and graph side by side that doesn't require ODS region? Any tips would be appreciated. Thanks!

%let todaysDate1 =  %sysfunc(today(), DATE9.);
%put &todaysDate1;

options orientation=landscape nodate pageno=1 leftmargin=.25in rightmargin=.25in topmargin=.25in bottommargin=.25in;
ODS pdf file="C:\ODSRegionOutput..pdf" style=journal bookmarklist=none pdftoc=2;
ODS layout start columns=2;
ODS region;
proc tabulate data=dataset1;
	class newage/missing preloadfmt mlf order=data s=[font_style=italic font_weight=bold CellWidth=200];
	class newrace/missing preloadfmt mlf order=data s=[font_style=italic font_weight=bold ];
         class Gender/missing mlf order=data s=[font_style=italic font_weight=bold ]; 
	class resident/missing mlf order=data s=[font_style=italic font_weight=bold];
	tables (ALL='Total' newage='Age' newrace='Race/Ethnicity' Gender='Sex' resident='Residence'),( N colpctn='(%)');
	format newage age. newrace racegrp.;
run;
ODS graphics on/ width=5.5in height=4in noborder;
ODS region;
proc sgplot data=dataset1;
	vbar date/ stat=sum  datalabelfitpolicy=rotate datalabel;
	xaxis label='Date' values = ('20DEC2020'd to  "&todaysDate1"d by day) valueattrs=(size=7pt);
	yaxis label='Number' ;
	format date MMDDYYS.;
run;
ODS graphics off;

ODS layout end;
ODS pdf close;

Re: ODS region

ChrisNZ — Sun, 24 Jan 2021 23:28:01 GMT

We ca't replicate as you use date we don;t have access to, but from your description this looks like a bug.

You should contact SAS Tech Support.

Re: ODS region

eramirez — Tue, 26 Jan 2021 14:37:21 GMT

Thank you. I contacted SAS support and indeed it is a bug. It has been reported. I used the columns= option and it worked.

topic Re: ODS region in SAS Programming

ODS region

Re: ODS region

Re: ODS region