how to get latest customer_id in bank loans

[BrahmanandaRao]

Hi Good Morning,

i have two columns  in bank loan application data 

in those columns 

1.Customer_id

2.Year

NOTE:-Customer_ID is not  in sequence and year is 2019 only not given mmddyyy format 

so how to get very latest customer id for applying for loan

[novinosrin]

Assuming you have a Date variable

proc sql;
select *
from have
having date=max(date);
quit;

The max function should give you the latest date

if it is year , just take the last record of the dataset

[BrahmanandaRao]

HI Novinosrin

in that FY' column only 2019 not given date month 

then how we get latest  customer_id and also customer_id is not in sequence 

[novinosrin]

Hi Can you plz post a sample? of your data and expected output?

[SASKiwi]

@BrahmanandaRao - If all you have to work with is a customer ID and a year not a proper date with day, month and year then I'd say you can't do it.

[Kurt_Bremser]

proc sort
  data=have
  out=sorted
;
by customer_id year;
run;

data want;
set sorted;
by customer_id;
if last.customer_id;
run;