topic Re: To create a new reverse variable in SAS Programming

To create a new reverse variable

xxz3231 — Sun, 31 Jan 2016 04:23:46 GMT

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!

Re: To create a new reverse variable

PGStats — Sun, 31 Jan 2016 04:48:23 GMT

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;

Re: To create a new reverse variable

Reeza — Sun, 31 Jan 2016 05:11:51 GMT

Salary_Reverse=500-Salary;

Re: To create a new reverse variable

xxz3231 — Tue, 02 Feb 2016 14:24:27 GMT

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!

Re: To create a new reverse variable

xxz3231 — Tue, 02 Feb 2016 14:24:56 GMT

Thank you very much,PG!It works well!

Re: To create a new reverse variable

Wang_Yajun — Tue, 02 Feb 2016 14:54:51 GMT

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;