SQL query

[UshaLatha]

Hi,

I have a query which gives the volume count of customers with A_ID=1 and B_ID=1.

I also need the count of customers having both A_ID=1 and B_ID=1. I have updated the code as follows (in red). But this does not give me the desired results.

proc sql;

select SUM(A_ID=1) as sum1, SUM(B_ID=1) as sum2,

SUM(A_ID=1,B_ID=1) as sum3

from table A,

left join table B

on A.CUST_ID=B.CUST_ID

;

quit;

My expected output is:

sum1	sum2	sum3
20	10	10

Please advise.

Thanks

[DBailey]

isn't i just SUM(A_ID=1 and B_ID=1) as sum3

[novinosrin]

Can you post a sample of what you have and the desired