need a variable wrt to other variable

[india2016]

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

[ChrisBrooks]

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;

[RW9]

proc sort data=have;
  by descending time_stamp;
run;
data want;
  set have;
  if _n_=1;
run;