Select only the latest entry for each client

[nicnad]

Hi,

Lets says I have the following table :

CUSTOMER_ID	ID	COMMENTS
12345	30	feadsaf
12345	32	argaefr
12345	33	dfasdsa
11111	46	fdasdfasd
11111	48	fadsfdas
34567	78	afsdffsd

What is the proper sas or sql query to create a table where I would have the customer_id and the comments only for the latest ID?

Thank you for your help and time.

[Reeza · Accepted solution]

Use a data step and last.

proc sort data=have; by customer_id id;

data want;

set have;

by customer_id;

if last.customer_id;

run;

OR two proc sorts;

proc sort data=have; by customer_id descending id; run;

proc sort data=have out=want nodupkey; by customer_id; run;

[nicnad]

Got it to work.

Thank you very much for your help!