reading next observation's value in current observation?

Question

I've a dataset called 'input' with the following observations ID Salary 10 1000 20 2000 30 3000 40 4000 I need an output dataset with following observations ID Salary Next_row_Salary 10 1000 2000 20 2000 3000 30 3000 4000 40 4000 null Note: The scenario is next obersavtion's salary should be the current observation's value for the column Next_Row_salary. If there is no next observation then the current observation's value for the column Next_Row_salary should be 'null'. Kindly help me out in creating a sas code for this scenario.

Answer 1

Here is the solution.

data raa;

input ID $ Salary;

datalines;

10 1000

20 2000

30 3000

40 4000

;

run;

data raa_final;

set raa curobs=curr_row end=eof;

if eof then do;

Next_row_Salary=.;

output;

stop;

end;

else do;

next_row=curr_row+1;

set raa(keep=Salary rename=(Salary=Next_row_Salary)) point=next_row;

output;

end;

run;