I have a dataset with time and survey_id as given below:
Time Survey_ID
07-06-2017 12:10 1234
16-06-2017 11:10 5678
I want to create a dataset wherein I want to select the survey_id and time WRT latest time
I have tried this code
proc sql;
create table login2 as select Survey_ID, max(Time_Stamp) format=datetime20. from work.login ;
quit;
but I am getting
Time Survey_ID
16-06-2017 11:10 1234
16-06-2017 11:10 5678
I want output as shown below:
Time Survey_ID
16-06-2017 11:10 5678
Try changing your SQL to include a Having Statement e.g. (and untested)
proc sql;
create table login2
as select survey_id, time_stamp format=datetime20.
from work.login
having time_stamp=max(timestamp);
quit;
proc sort data=have; by descending time_stamp; run; data want; set have; if _n_=1; run;
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.