To create a new reverse variable

[xxz3231]

Hi,Everyone,

I have a question about how to create a new variable which is in the reverse order of another one;

for instance ,this is the dataset,

NAME   SALARY

JACK    100

LUCY    200

MIKE     300

KATE    400

What I need is to create a new variable say "SALARY_REVERSE" to make the dataset looks like the follows

NAME SALARY SALARY_REVERSE

JACK   100               400

LUCY   200              300

MIKE   300               200

KATE   400              100

Thank you very much!

[PGStats · Accepted solution]

Sounds silly 

proc sort data=have out=haver; by descending salary ; run;

data want;
set have;
set haver(keep=salary rename=salary=reverse_salary);
run;

[xxz3231]

Thank you very much,PG!It works well!

[Reeza]

Salary_Reverse=500-Salary;

[xxz3231]

Hi,Reeza,thank you very much! But the real data is much more complicated, I need a more general solution,PGStats' solution works well,thank you again!

[Wang_Yajun]

Hi,

Let's say the dataset name is test, my solution is below

*Label Observation Number;
data test;
set test;
N = _N_;
run;

*Reverse the Order;
proc sort data = test out = test_reverse; by decending _N_;run;

*Relabel Observation Number;
data test_reverse;
set  test_reverse;
N=_N_;
run;

*Merge the two datasets;
data test_combine;
set test test_reverse;
by N;
run;