Sum up with

[Mattress58]

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

ScoreX	WeightX
1	10
0	23
0	45
4	20
2	20
1	5
1	5

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)

so

60/20

How can I do this?

[PaigeMiller]

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]

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;

[PaigeMiller]

I think you want

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

[Mattress58]

Thank you both for the help.