Help using Base SAS procedures

Select only the latest entry for each client

Accepted Solution Solved
Reply
Regular Contributor
Posts: 186
Accepted Solution

Select only the latest entry for each client

Hi,

Lets says I have the following table :

CUSTOMER_IDIDCOMMENTS
1234530feadsaf
1234532argaefr
1234533dfasdsa
1111146fdasdfasd
1111148fadsfdas
3456778afsdffsd

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.


Accepted Solutions
Solution
‎02-07-2013 01:40 PM
Super User
Posts: 19,822

Re: Select only the latest entry for each client

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;

View solution in original post


All Replies
Solution
‎02-07-2013 01:40 PM
Super User
Posts: 19,822

Re: Select only the latest entry for each client

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;

Regular Contributor
Posts: 186

Re: Select only the latest entry for each client

Got it to work.

Thank you very much for your help!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 135 views
  • 0 likes
  • 2 in conversation