SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

pulling the latest record based on date

Reply
Contributor
Posts: 31

pulling the latest record based on date

I have a table which has the below contents

email_addr       date_enrolled

x@gmail.com     05/10/2008
x@gmail.com       01/01/2014

x@gmail.com       05/05/2014

I need the latest record of 05/05/2014 by leaving the other records.  Can i use first function ? Is there any easy way?

Thanks,

Super User
Super User
Posts: 7,988

Re: pulling the latest record based on date

Double post, please see other response.

Community Manager
Posts: 567

Re: pulling the latest record based on date

Thanks RW9. Here is the other post with replies for reference on this community:

pulling the latest record based on date

Anna

Ask a Question
Discussion stats
  • 2 replies
  • 221 views
  • 0 likes
  • 3 in conversation