Create a table of items by price

avepo — Wed, 19 Sep 2018 15:43:07 GMT

Hi,

I have a dataset of items and their prices.

Items Price

a 10

b 1000

c 200

d 500

How do I create a table that shows items by descending order of price?

Items price

b 1000

d 500

c 200

a 10

Thanks for your help!

Re: Create a table of items by price

PeterClemmensen — Wed, 19 Sep 2018 15:45:21 GMT

Like this

data have;
input Items $ Price;
datalines;
a 10
b 1000
c 200
d 500
;

proc sort data=have out=want;
   by descending Price;
run;