topic Re: Print sql columns values in reverse order in SAS Programming

Print sql columns values in reverse order

Aayushi_17 — Mon, 11 Mar 2019 15:54:50 GMT

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

Re: Print sql columns values in reverse order

novinosrin — Mon, 11 Mar 2019 15:59:35 GMT

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;

Re: Print sql columns values in reverse order

novinosrin — Mon, 11 Mar 2019 16:01:50 GMT

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;

Re: Print sql columns values in reverse order

Aayushi_17 — Tue, 12 Mar 2019 02:11:25 GMT

Thank you... This worked

Re: Print sql columns values in reverse order

Ksharp — Tue, 12 Mar 2019 13:28:35 GMT

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;