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
isn't i just SUM(A_ID=1 and B_ID=1) as sum3
Can you post a sample of what you have and the desired
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.