topic Re: finding lower and upper bounds of a data in SAS Programming

finding lower and upper bounds of a data

R2211BAL — Tue, 09 Oct 2018 14:57:39 GMT

New to SAS.. Working on SAS Studio, Looking for SAS code for the following scenario

I have a data with the following variables

city A city B Miles Price

a1 a2 1059 150

a1 a3 1089 150

a1 a4 1509 200

a1 a5 600 150

a1 a6 1989 200

And I am looking to create an output like

City A Miles-Lowerlimit Miles-Upperlimit Price

a1 600 1089 150

a1 509 1989 200

Thank You!!

Re: finding lower and upper bounds of a data

Kurt_Bremser — Tue, 09 Oct 2018 15:08:52 GMT

proc sql;
create table want as
select
  city_a,
  price,
  min(miles) as miles_low,
  max(miles) as miles_high
from have
group by city_a, price;
quit;

Re: finding lower and upper bounds of a data

PeterClemmensen — Tue, 09 Oct 2018 15:11:51 GMT

Do like this

data have;
input city_A $ city_B $ Miles Price;
datalines;
a1 a2 1059 150
a1 a3 1089 150
a1 a4 1509 200
a1 a5 600 150
a1 a6 1989 200
;

proc sql;
   create table want as
   select city_A
         ,min(Miles) as Miles_Lowerlimit
         ,max(Miles) as Miles_Upperlimit
         ,price
   from have
   group by city_A, price;
quit;