Create a table of items by price

[avepo]

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!

[PeterClemmensen · Accepted solution]

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;