topic Choosing minimum value on matching variable in SAS Programming

Choosing minimum value on matching variable

JediApprentice — Tue, 28 Mar 2017 19:34:25 GMT

I have this dataset:

data x;
  infile datalines;
  input id r2d2 price;
  datalines;
15 12 10
15 12 14
22 17 12
88 16 23
22 17 10
22 15 34
88 15 95
;;
run;

What I'd like to do is - for observations that have the same value for r2d2, I want to output only the observation with the lowest price. How would I go about doing this

Re: Choosing minimum value on matching variable

Reeza — Tue, 28 Mar 2017 19:41:27 GMT

Sort the data so that the smallest value is first and then use SAS FIRST logic to keep the record.

Re: Choosing minimum value on matching variable

PaigeMiller — Tue, 28 Mar 2017 19:45:37 GMT

An SQL solution

--- UNTESTED CODE ----

proc sql;
    create table new as select * from x group by r2d2 having price=min(price);
quit;