How to filter for two attributes?

[LMSSAS]

I have the following proc sql and output below.  I am trying to solve for remove duplicates by pulling in the INDV_CHNL_PTNR_ID with the MAX (Cert_Ranking). The Cert_Ranking column comes from a case statement I created in the original table. The having clause I am using is not working. Does anyone have any suggestions? 

proc sql; create table test as
select distinct 
* 
from MedicareSalesAgencies
having max(Cert_Ranking) and indv_chnl_ptnr_id
; quit;

INDV_CHNL_PTNR_ID	Cert_Ranking
29	11
29	3
29	2
29	11
29	3
29	2
29	11
29	3
29	2
29	11
29	3
29	2
34	3
34	2
34	3
34	2
34	3
34	2
34	3
34	2
34	3
34	2
34	3
34	2
34	3
34	2
34	3
34	2

[Reeza · Accepted solution]

proc sql; create table test as
select 
indv_CHNL_PTNR_ID, max(CERT_RANKING) as CERT_RANKING
from MedicareSalesAgencies
group by indv_CHNL_PTNR_ID
; quit;

Does that give you what you expect? If not, please post the desired outcome and we can help with the query. 

[LMSSAS]

That gives me the desired outcome, Thank you!