01-30-2016 11:23 PM
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,
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!
02-02-2016 09:54 AM
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;
Need further help from the community? Please ask a new question.