find min value in a column within different groups

[echoli]

 Hi All,

How to output the min value in a column within different groups? I want to use data step, not proc sql.

I have a data like below, I want output min pValue in each group. The observations in red color are what I want. Any idea? THanks,

Obs	group	Sex	pValue
1	(2) Young	Female	0.0023
2	(2) Young	Male	0.0536
3	(3) Child	Female	0.0814
4	(3) Child	Male	0.3191
5	(4) Teen	Female	0.0561
6	(4) Teen	Male	0.0979

[novinosrin]

Hi , May i ask why not proc sql? Thanks

[echoli]

Oh, nothing, I just want to know how to do it in data step.

[Reeza · Accepted solution]

Sort it and use FIRST.

proc sort data=have;
by myByGroup pvalue;
run;

data want;
set have;
by myByGroup ;

if first.myByGroup;

run;

The SQL solution is one step.

[ballardw]

Please show exactly what you expect the output for that example data to look like.

[echoli]

Hi ballardw,

I've marked the observations as red color.

Thanks,

C