topic Re: Retain Last obs to new variable in SAS Procedures

Retain Last obs to new variable

R_Win — Wed, 27 Apr 2011 13:41:02 GMT

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

Re: Retain Last obs to new variable

SPR — Wed, 27 Apr 2011 13:59:18 GMT

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

Re: Retain Last obs to new variable

DBailey — Wed, 27 Apr 2011 14:35:09 GMT

just for clarification....

set l end=l;

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

Re: Retain Last obs to new variable

Ksharp — Thu, 28 Apr 2011 01:32:13 GMT

[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