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
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.
I would do it the same way you did.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.