topic Select only the latest entry for each client in SAS Procedures

Select only the latest entry for each client

nicnad — Thu, 07 Feb 2013 18:38:12 GMT

Hi,

Lets says I have the following table :

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 — Thu, 07 Feb 2013 18:40:43 GMT

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 — Thu, 07 Feb 2013 18:52:59 GMT

Got it to work.

Thank you very much for your help!