topic need a variable wrt to other variable in SAS Programming

need a variable wrt to other variable

india2016 — Fri, 16 Jun 2017 09:59:45 GMT

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 — Fri, 16 Jun 2017 10:19:36 GMT

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 — Fri, 16 Jun 2017 10:27:29 GMT

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