Second last value of a column

[thomash123]

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

     id

  ) b

  on

  (

  a.id = b.id

  and

  a.version = b.version_before

)

  where

  something = some_value

  ;

Thanks a lot,

th

[data_null__]

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]

I would do it the same way you did.