Retain Last obs to new variable

[R_Win]

data l;
input id;
cards;
45
63
1023
run;

Now i want to retain the last obs to new variable;

output:
id new_id
45 1023
63 1023
1023 1023
Here 1023 is the last obs it shold move to new variable new_id

[SPR]

Hello R_Win;

This is a solution:
[pre]
data l;
input id;
cards;
45
63
1023
run;
data _null_;
set l end=l;
if l then call symputx ('id',id);
run;
data r;
set l;
new_id=&id;
run;
[/pre]
Sincerely,
SPR

[DBailey]

just for clarification....

set l end=l;

That's the letter L...not the number 1. Sometimes confusing in certain fonts.

[Ksharp]

[pre]
data l;
input id;
cards;
45
63
1023
;
run;

data want;
set l nobs=nobs;
if _n_ eq 1 then set l(rename=(id=new_id)) point=nobs;
run;
[/pre]

Ksharp