Solved: Creating Start year by Name

ccaudillo100 · Posted 01-13-2023 02:01 PM

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

ccaudillo100 · Posted 01-13-2023 02:24 PM

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

ccaudillo100 · Posted 01-13-2023 02:24 PM

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

Creating Start year by Name