topic Re: How to Divide two rows? in SAS Procedures

How to Divide two rows?

Phoenix8527 — Thu, 07 Mar 2013 21:48:23 GMT

Here is my dataset. I want to calculate Percentage as Y/(Y+N) using Count number for both NBUS and Season. Anyone know how to get the results? Thanks a lot

Status	Tenure	Count
N	NBUS	543
N	Season	1099
Y	NBUS	276
Y	Season	264

Re: How to Divide two rows?

DBailey — Thu, 07 Mar 2013 22:27:44 GMT

data have;

input Status $ Tenure $ Count;

cards;

N NBUS 543

N Season 1099

Y NBUS 276

Y Season 264

run;

proc sql;

create table want as

select status, tenure, count, count/sum(count) as Pct

from have;

quit;

Re: How to Divide two rows?

Phoenix8527 — Fri, 08 Mar 2013 14:20:33 GMT

The Final result I want to get is 276/(276+543) for NBUS, 264/(264+1099) for Season.

Re: How to Divide two rows?

DBailey — Fri, 08 Mar 2013 14:37:08 GMT

proc sql;

create table want as

select status, tenure, count, count/sum(count) as Pct

from have

group by tenure;

quit;

Re: How to Divide two rows?

VD — Fri, 08 Mar 2013 14:38:25 GMT

proc sql;

create table want1 as select

status, tenure, count, sum(count) as sum

from have

group by tenure;

quit;

proc sql;

create table want2 as select

status, tenure, count/sum*100 as percent

from want1

where status='Y';

quit;

Re: How to Divide two rows?

data_null__ — Fri, 08 Mar 2013 14:45:34 GMT

Times 100.

title "276/(276+543)=%sysevalF(276/(276+543)) for NBUS, 264/(264+1099)=%sysevalF(264/(264+1099)) for Season"; 
proc freq data=have;
   tables status*tenure / norow nopercent; 
   weight count;
   run;