topic Re: One row needs to be selected in SAS Programming

One row needs to be selected

Sarojkumar — Mon, 30 Aug 2010 14:00:01 GMT

I have a dataset like this:

data hello;
input id var1 var2;
datalines;
1 3 5
1 3 7
2 2 4
2 2 7
2 2 9
3 4 6
3 4 9
;
run;

I want to output only one row where the difference beetween var1 and var2 is lowest for the particular id.

Any help.

Re: One row needs to be selected

sbb — Mon, 30 Aug 2010 14:28:56 GMT

Consider PROC SQL with a sub-query (to get the minimum) or a DATA step using a MERGE / BY statement technique, while using a PROC SUMMARY to get the minimum value for your BY group.

Scott Barry
SBBWorks, Inc.

Re: One row needs to be selected

FredrikE — Mon, 30 Aug 2010 15:23:52 GMT

Something like this???

data one/view=one;
set hello;
length diff 8;
diff = var1 - var2;
run;

proc sort data = one out = two;
by id diff;
run;

data three;
set two;
by id diff;
if first.id then output;
run;

Re: One row needs to be selected

Peter_C — Mon, 30 Aug 2010 17:49:15 GMT

> Something like this???
>
>
> data one/view=one;
> set hello;
> length diff 8;
> diff = var1 - var2;
> un;
>
> proc sort data = one out = two;
> by id diff;
> un;
>
> data three;
> set two;
> by id diff;
> if first.id then output;
> un;

good approach and allowing ID groups.
May need refinement to ensure dif is only positive.

The first refinement[pre]> diff = abs( var1 - var2) ;[/pre]

peterC