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

SAS Innovate 2025: Register Now

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!

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
  • 1867 views
  • 2 likes
  • 3 in conversation