Filter based on max() in SQL

[112211]

Only extract max height values  based on sex and iam tried below code
proc sql ;
select *, max(height) as height
from clss
group by sex ;
quit;

Data following:

data clss ;
input Name$ Sex$ Age Height Weight ;
cards ;
ghj F 14 50.5 75
HGG F 15 55 80
TYY M 14 52 75
OIU F 15 54 81
POI M 16 65 72
POJ M 15 62 87
KJN F 16 60 81
JHB M 14 61 75
HGV M 11 60 57
NHJ F 12 75 75
JHB M 13 70 55
HGS F 14 65 60
TRT M 13 60 55
QWA F 14 51 65
;

I need output like this
name sex age height weight
NHJ     F    12       75       75
JHB     M   13       70       55

[LinusH · Accepted solution]

If you wish to filter on an aggregation use the HAVING key word, like

Having height = max(height)