topic Re: how to place 2 tables horizontally for easy comparison in Graphics Programming

how to place 2 tables horizontally for easy comparison

harsh0404 — Tue, 10 Sep 2019 18:40:39 GMT

title " actual_rev" ;
proc tabulate data=have;
   class decile agegroup ;
   var actual_rev;
   table decile=' ', 
        agegroup *EXP_RPP=''*mean=''
         /misstext=' ' box=decile;
run; 

title "proj_rev" ;
proc tabulate data=have;
   class decile agegroup ;
   var proj_rev;
   table decile=' ', 
       agegroup *proj_rev=''*mean=''
         /misstext=' ' box=decile ;
run;

I have to compare 2 tables here. projected revenue and actual revenue (table is by decile and age group).

When i run in SAS, I get tables one after another vertically.

My boss wants it placed horizontally to each other for easy comparison. in this one i went to excel and used pivot table.. (please ignore the values inside and the name of the variables)

Re: how to place 2 tables horizontally for easy comparison

DanH_sas — Tue, 10 Sep 2019 18:50:31 GMT

Something like the following should work for you:

ods _all_ close;
ods html;
ods layout gridded columns=2;
ods region;
proc print data=sashelp.class; run;
ods region;
proc print data=sashelp.class; run;
ods layout end;
ods html close;

Hope this helps!

Dan

Re: how to place 2 tables horizontally for easy comparison

Rick_SAS — Tue, 10 Sep 2019 19:54:14 GMT

To expand on Dan's suggestion, see

Using the ODS statement to add layers in your ODS sandwich

Arrange matrices and graphs in a gridded layout