Filter based on max() in SQL

112211 — Wed, 20 Sep 2023 11:36:57 GMT

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

Re: PROC SQL

LinusH — Wed, 20 Sep 2023 11:35:52 GMT

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

Having height = max(height)

topic Re: PROC SQL in SAS Programming

Filter based on max() in SQL

Re: PROC SQL