topic Re: Picking last value and assign it to variable in SAS Programming

Picking last value and assign it to variable

Cho8 — Fri, 13 Nov 2020 15:36:08 GMT

X	A	B	C
X1	4	5	6
X2	10	11	13
X3	5	9	10
FirstQtr	1	8	5
LTV	6	4	2

I want to pickup the last value of column 'C' (Marked in Color). and assign it to variable New_var.

Desired O/p

New_var=2 ;

I need it in dataset.

Re: Picking last value and assign it to variable

GBL__ — Fri, 13 Nov 2020 15:49:12 GMT

Use the END= data set option:

DATA two ;

SET one END=last ;

IF last THEN DO ;

New_Var=C ;

END ;

RUN ;

Re: Picking last value and assign it to variable

novinosrin — Fri, 13 Nov 2020 15:51:34 GMT


data have;
 input X $	A 	B	C;
 cards;
X1	4	5	6
X2	10	11	13
X3	5	9	10
FirstQtr	1	8	5
LTV	6	4	2
;


data want;
 set have;
 if _n_=1 then set have(keep=c rename=c=new_var) point=nobs nobs=nobs;
run;

Re: Picking last value and assign it to variable

Kurt_Bremser — Fri, 13 Nov 2020 15:50:13 GMT

data want;
set have (keep=c) nobs=nobs point=nobs;
rename c=new_var;
output;
stop;
run;

Reads only the last observation, and keeps variable c under a new name.