topic Re: find min value in a column within different groups in SAS Programming

find min value in a column within different groups

echoli — Thu, 04 May 2017 20:05:12 GMT

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,

novinosrin — Thu, 04 May 2017 19:54:34 GMT

Hi , May i ask why not proc sql? Thanks

ballardw — Thu, 04 May 2017 20:02:51 GMT

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

echoli — Thu, 04 May 2017 20:05:56 GMT

Hi ballardw,

I've marked the observations as red color.

Thanks,

echoli — Thu, 04 May 2017 20:06:46 GMT

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

Reeza — Thu, 04 May 2017 20:13:28 GMT

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.