topic Second last value of a column in SAS Programming

Second last value of a column

thomash123 — Fri, 20 Jul 2012 13:48:54 GMT

Hi all,

is there a way in SAS to find the second last value of a column quicker than with something like

proc sql;

create table &_output. as

select

a.id,

a.version,

a.value_to_be_looked_up

from

abc.zzz a

join

(

select id, max(version)-1 as version_before

from

abc.zzz

group by

) b

(

a.id = b.id

and

a.version = b.version_before

)

where

something = some_value

;

Thanks a lot,

data_null__ — Fri, 20 Jul 2012 14:54:22 GMT

Do you want second largest value or the next to the last row in a data set? Do don't follow your SQL and you didn't include any data for it to use.

tish — Fri, 20 Jul 2012 15:34:39 GMT

I would do it the same way you did.