Counting with conditions in proc sql

[TheNovice]

This maybe overly simple but I am stuck...

My data is like this:

ID	Series	S_Days	P_days
1	1	1_30	150_200
2	5	1_30	150_200
3	5	1_30	150_200
4	1	91_120	NP
5	5	61_90	NP
6	5	61_90	0_30

I need to count the number of ID's where P_days = NP and does not equal NP and group it by Series and S Days

I wrote the following but it's not working... 

proc sql;
create table test as
select Series ,s_days
(case when p_days = 'NP' then count(ban) end) as NP,
(case when p_days ^= 'NP' then count(ban) end) as Pay
from Master
group by Series, S_days
;
quit;

would really appreciate any suggestions. Thank you.

[TheNovice · Accepted solution]

I figured it out 🙂

count(case when (p_days ='NP') then ban end) as NP