topic finding the percent age in total column in SAS Programming

finding the percent age in total column

tlnarayana26 — Fri, 06 Feb 2015 11:57:34 GMT

year	x	y	percent
2010	10	5	50%
2011	23	6	26%
2012	25	2	8%
2013	20	4	20%
2014	17	8	47%
total	95	25	26%

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

(i want 26% in totals)

plz help me

Re: finding the percent age in total column

BrunoMueller — Fri, 06 Feb 2015 12:16:35 GMT

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>

Re: finding the percent age in total column

RW9 — Fri, 06 Feb 2015 13:08:37 GMT

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;

Re: finding the percent age in total column

ballardw — Fri, 06 Feb 2015 15:54:55 GMT

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;