Print sql columns values in reverse order

[Aayushi_17]

How can I select rows in reverse order?

For example I have a column sample1 which has values like. This

Sample1

1
2
A
Sr
R
Y
7

The output I want is :

7
Y
R
Sr
A
2
1


I anyone knows please help me.. Thanks in advance

[novinosrin]

data have;
input var $;
cards;
1
2
A
Sr
R
Y
7
;

proc sql;
create table want(drop=rn) as
select *,monotonic() as rn
from have
order by rn desc;
quit;

[novinosrin · Accepted solution]

And if you do NOT mind a NOTE in the log stating "NOTE: The query as specified involves ordering by an item that doesn't appear in its SELECTclause."

data have;
input var $;
cards;
1
2
A
Sr
R
Y
7
;

proc sql;
create table want as
select *
from have
order by monotonic()  desc;
quit;

[Aayushi_17]

Thank you... This worked

[Ksharp]

If your table is not very big.

data have;
input var $;
cards;
1
2
A
Sr
R
Y
7
;

data want;
 do i=nobs to 1 by -1;
  set have nobs=nobs point=i;
  output;
 end;
 stop;
 drop i;
run;