Creating Start year by Name

ccaudillo100 — Fri, 13 Jan 2023 19:01:14 GMT

Hello, I am trying to take a table from looking like this

to this

using SAS. Any code advice is appreciated.

Any provided methods will be used on 60K+ lines of data. Not posting that information here for privacy Reasons.

Names are in Character Format and Years are in Numeric Format

Re: Creating Start year by Name

ccaudillo100 — Fri, 13 Jan 2023 19:24:02 GMT

proc summary data=Have nway ;
class Name;
var Year;
output out=Want min(Year)=Start Year max(Year)=LastYear;
run;