finding the percent age in total column

Reply
Contributor
Posts: 40

finding the percent age in total column

yearxypercent
201010550%
201123626%
20122528%
201320420%
201417847%
total952526%

The above report gets total and %'s in total column .

(i want 26% in totals)

plz help me

SAS Super FREQ
Posts: 676

Re: finding the percent age in total column

You can use Proc REPORT to get the output you need. You can make use of the computed column functionality:

<

data have;
  infile cards dlm=",";
 
input
    year x y
  ;
cards;
2010,10,5
2011,23,6
2012,25,2
2013,20,4
2014,17,8
;

proc report data=have nowindows;
 
column year x y myPct;
  define year / display;
 
define x / analysis;
 
define y / analysis;
 
define myPct / computed format=percent9.0;

 
compute myPct;
    myPct = y.sum / x.sum;
 
endcomp;

 
rbreak after / summarize;
run;

/body>

Esteemed Advisor
Esteemed Advisor
Posts: 7,195

Re: finding the percent age in total column

Hi,

proc sql;

     create table WANT as

     select     *

     from       HAVE

     union all

     select     "Total" as YEAR,

                    count(X) as X,

                    count(Y) as Y,

                    round((CALCULATED Y / CALCULATED X) * 100,1.) as PERCENT

     from        HAVE;

quit;

Grand Advisor
Posts: 10,196

Re: finding the percent age in total column

And a Tabulate solution

proc tabulate data=have;

   class year;

   var x y;

   table year='' all='Total',

         x *sum=''*f=best4.     y=''*(sum='y'*f=best4. pctsum<x>='%'*f=best4.)

         /box='Year' ;

run;

Ask a Question
Discussion stats
  • 3 replies
  • 202 views
  • 0 likes
  • 4 in conversation