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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.