Percentage of values that increase out of total number of values which shows a change.

[SASuser4321]

I have two columns in a table. 

I need to find the number of rows in which the number in Rating_a is bigger than the number in Rating_b and then divide that number by the total number of rows in the table in which the value changes. So when dividing, I won't be taking into account those rows in which the values in Rating_a and Rating_b are the same. For instance, in the following table, the result I'd be looking for is 2/4 = 50%. I divide by 4 instead of 6 because 2 rows have the same values. And in the numerator I wrote 2 because only in 2 rows, rating_a is bigger than rating_b. Help would be appreciated in coming up with a code that deals with this since I'm dealing with 1000s of rows in my table. Thank you.

Here's a sample (actual table has 1000s of rows) of how it looks like:

Rating_a	Rating_b
1	3
2	2
4	2
4	4
2	1
3	4

[PaigeMiller]

Since you marked an answer correct to your other question, can you see if you can make the simple modifications to that answer? Show us what you have tried.

[SASuser4321 · Accepted solution]

I figured it out on my own. 🙂

proc sql;
select sum(rating_a > rating_b) / sum(rating_a ne rating_b) from have;
quit;