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;
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.
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.