SQL query

UshaLatha — Mon, 29 Oct 2018 16:02:11 GMT

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

Re: SQL query

DBailey — Mon, 29 Oct 2018 16:06:38 GMT

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

Re: SQL query

novinosrin — Mon, 29 Oct 2018 16:25:38 GMT

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

topic SQL query in SAS Programming

SQL query

Re: SQL query

Re: SQL query