topic Re: Two histograms on a graph in SAS Programming

Two histograms on a graph

ChuksManuel — Mon, 26 Jul 2021 00:36:18 GMT

Is it possible to print two histograms on a graph using proc sgplot?
My code has been:

proc sgplot data=me;
where num_days=:'Days 100 - 200';
histogram obese/ fillattrs=(color=pink) nbins=5  showbins;
run;

The above code me just one histogram. How do I add a histogram of a second variable "sex" alongside that of "obese" on the same graph.

Re: Two histograms on a graph

ChrisNZ — Mon, 26 Jul 2021 02:38:39 GMT

So one X axis showing 2 variables side by side?

Re: Two histograms on a graph

ChuksManuel — Mon, 26 Jul 2021 02:41:14 GMT

Yes!

Re: Two histograms on a graph

ChrisNZ — Mon, 26 Jul 2021 03:45:32 GMT

What does the Y axis look like?

Re: Two histograms on a graph

ChuksManuel — Mon, 26 Jul 2021 04:26:38 GMT

Y is a percentage.

Re: Two histograms on a graph

ChrisNZ — Mon, 26 Jul 2021 05:13:41 GMT

Here is a (very ugly) way. There might be better ways.

data PLOT;
  set SASHELP.CLASS;
  length X $10;
  X=cats(AGE); PCT=AGE/2; output;
  X=SEX      ; PCT + 3;   output;
  if _N_=1 then do; X='A'; PCT=0; output; end;
run;

proc format ; value $xaxis 'A '='  ';
 
ods graphics on / width=1000px height=400px;
proc sgplot data=PLOT; 
  vbar X / response=PCT attrid=X;
  format X $xaxis.;
  xaxis label= "%sysfunc(repeat(%str( ),50)) Age %sysfunc(repeat(%str( ),120)) Sex" ;
run;

Re: Two histograms on a graph

ChuksManuel — Mon, 26 Jul 2021 06:25:16 GMT

Thanks!