BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Calcite | Level 5

## To create a new reverse variable

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Opal | Level 21

## Re: To create a new reverse variable

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;``````
PG
5 REPLIES 5
Opal | Level 21

## Re: To create a new reverse variable

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;``````
PG
Calcite | Level 5

## Re: To create a new reverse variable

Thank you very much,PG!It works well!
Super User

## Re: To create a new reverse variable

``Salary_Reverse=500-Salary;``
Calcite | Level 5

## Re: To create a new reverse variable

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!
Obsidian | Level 7

## Re: To create a new reverse variable

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;

``````
Discussion stats
• 5 replies
• 2145 views
• 0 likes
• 4 in conversation