topic Find latest date reported per year in a set of million+ rows over 10 year span in SAS Programming

Find latest date reported per year in a set of million+ rows over 10 year span

bssiders — Tue, 12 Dec 2023 19:29:28 GMT

I have a set of data where I want to find the max date per year. Somewhat like this:

proc sql;

create table x as select

max(account_date) as last_day format date9.

from y

;quit;

However, the last date per year can vary so instead of grabbing the last date for the entire set, I want to subset by year. The output would look something like this:

Year MaxDate

2011 10OCT2011

2012 14NOV2012

2013 31DEC2013

2014 05JUL2014

2015 31DEC2015

.... and so on

There has to be a simple way with a few lines of code vs many. Any help would be appreciated!

Re: Find latest date reported per year in a set of million+ rows over 10 year span

PaigeMiller — Tue, 12 Dec 2023 19:31:55 GMT

proc summary data=have nway;
    class year;
    var account_date;
    output out=want max=maxdate;
run;

This assumes you already have a variable named YEAR, if you don't that's easily fixed.

Re: Find latest date reported per year in a set of million+ rows over 10 year span

bssiders — Tue, 12 Dec 2023 19:36:09 GMT

your the man!