topic Re: I need to count the number of unique Churn based on the Account_length in SAS Procedures

I need to count the number of unique Churn based on the Account_length

Doe — Sun, 31 May 2020 03:11:46 GMT

I need to count the unique number of Churn based on the Account_length. The sample data is provided below:

The result should be like this

Account_length Churn Count

1 False 7
1 True 1
2 True 1
2 False 1

Any help or advice appreciated,

Cheers,

Doe

Doe — Sun, 31 May 2020 03:14:57 GMT

* Correction to the expected results

The result should be like this

Account_length Churn Count

1 False 7
1 True 1
2 True 1
3 False 1

Any help or advice appreciated,

Cheers,

Doe

novinosrin — Sun, 31 May 2020 03:16:12 GMT

Hi @Doe A simple proc freq?

proc freq data=have;
tables account_length*churn;
run;

novinosrin — Sun, 31 May 2020 03:20:11 GMT

proc sql;

select account_length, churn, count(churn) as count

from have

group by account_length, churn;

quit;

Doe — Sun, 31 May 2020 03:22:16 GMT

thanks a lot!!