BookmarkSubscribeRSS Feed
harsh0404
Fluorite | Level 6
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)

putthisplease.PNGwewantac tual.PNG

2 REPLIES 2
DanH_sas
SAS Super FREQ

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2176 views
  • 2 likes
  • 3 in conversation