topic Re: how to get latest customer_id in bank loans in SAS Programming

how to get latest customer_id in bank loans

BrahmanandaRao — Sun, 29 Dec 2019 04:43:50 GMT

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 — Sun, 29 Dec 2019 04:54:42 GMT

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 — Sun, 29 Dec 2019 05:28:46 GMT

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 — Sun, 29 Dec 2019 05:33:43 GMT

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

SASKiwi — Sun, 29 Dec 2019 05:50:59 GMT

@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 — Sun, 29 Dec 2019 09:11:45 GMT

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

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