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)
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
To expand on Dan's suggestion, see
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.