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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.