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,
Double post, please see other response.
Thanks RW9. Here is the other post with replies for reference on this community:
Anna
Join us for SAS Community Trivia
SAS Bowl XXIX, The SAS Hackathon
Wednesday, March 8, 2023, at 10 AM ET | #SASBowl
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.