topic Re: last value in a row in SAS Programming

last value in a row

J_J_J — Mon, 20 May 2019 11:55:42 GMT

Please help me with code.

I'd like to get table with 2 columns: title1 & last value in a row (in i.e. bold) = last column with value from title2 to title_n. Number of columns is not known, it can be 100 or more.

title1	title2	title3	title4	title5
B643B0C	B643B0C	3090E43	BCC0E18	8F2E437
EF6E8A4	EF6E8A4
D1CA75B	D1CA75B	8AF3241	DC24E41
30CCDFB	30CCDFB	379E9CF
E498CD8	E498CD8
58CB971	BD6A93E	BD6A93E
27B35FC	27B35FC	C4F7E5D	4F507FE	8F00A10
EA06B97	EA06B97	BD6A93E	11692E8
ADFD3E7	ADFD3E7	1794801
1B43CC4	1B43CC4	984A9CE	2F9769A	1540CC5

Hope for your help.

Re: last value in a row

Jagadishkatam — Mon, 20 May 2019 12:45:33 GMT

please try coalescec

data want;
set have;
last=coalescec(of title5-title2);
keep title1 last;
run;

Re: last value in a row

novinosrin — Mon, 20 May 2019 13:04:01 GMT

Hi @J_J_J


data have;
infile cards truncover;
input (title1	title2	title3	title4	title5) (:$10.);
cards;
B643B0C	B643B0C	3090E43	BCC0E18	8F2E437
EF6E8A4	EF6E8A4	 	 	 
D1CA75B	D1CA75B	8AF3241	DC24E41	 
30CCDFB	30CCDFB	379E9CF	 	 
E498CD8	E498CD8	 	 	 
58CB971	BD6A93E	BD6A93E	 	 
27B35FC	27B35FC	C4F7E5D	4F507FE	8F00A10
EA06B97	EA06B97	BD6A93E	11692E8	 
ADFD3E7	ADFD3E7	1794801	 	 
1B43CC4	1B43CC4	984A9CE	2F9769A	1540CC5
;


data want;
set have;
array t(*) title:;
want=choosec(dim(t)-cmiss(of t(*)),of t(*));
run;

Re: last value in a row

J_J_J — Tue, 21 May 2019 05:12:45 GMT

Jagadishkatam, thank you so much, it works!

Re: last value in a row

J_J_J — Tue, 21 May 2019 05:13:49 GMT

Thanks