DATA Step, Macro, Functions and more

Second last value of a column

Reply
Contributor
Posts: 38

Second last value of a column

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

Respected Advisor
Posts: 3,799

Re: Second last value of a column

Posted in reply to thomash123

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.

Contributor
Posts: 52

Re: Second last value of a column

Posted in reply to thomash123

I would do it the same way you did.

Ask a Question
Discussion stats
  • 2 replies
  • 608 views
  • 0 likes
  • 3 in conversation