topic Re: Sum up with in SAS Procedures

Sum up with

Mattress58 — Thu, 27 Aug 2015 14:24:23 GMT

I created a table named rentals. This is what it pulls back.

I need to come up with the result being

Score
3

Which is a formula of (sum All weightX wher scoreX not = to 0) / (sum All weightx where score = to 1)

60/20

How can I do this?

PaigeMiller — Thu, 27 Aug 2015 14:33:37 GMT

data oink;

set rentals end=eof;

if scoreX^=0 then numerator+weightx;

if scoreX=1 then denominator+weightx;

if eof then score=numerator/denominator;

run;

Reeza — Thu, 27 Aug 2015 14:48:30 GMT

It's 68/20=3.4 given your data.

Here's a SQL solution...

proc sql;

create table want as

select sum((scorex=0)*weightx)/sum((scorex=1)*weightx) as score

from have;

quit;

Mattress58 — Thu, 27 Aug 2015 16:11:45 GMT

Thank you both for the help.

PaigeMiller — Thu, 27 Aug 2015 18:27:57 GMT

I think you want

select sum((scorex ne 0)*weightx)/sum((scorex=1)*weightx) as score