i am using proc sql case(count statement but is not working

[Reeza]

Count of 1 or 0 is always 1, so the N is the same no matter what your values. 

Try using a SUM instead.

[RW9 · Accepted solution]

You want sum rather than count - count will count records regardless of if they are 1 or 0.

proc sql;
create table mstats as
select actarm,country,
sum(case when ITTFL="Y" then 1 else 0 end) as rand,
sum(case when SAFFL="Y" then 1 else 0 end) as SAF,
sum(case when FASFL="Y" then 1 else 0 end) as FAS
from disp_ps
group by actarm,country;
quit;