DATA Step, Macro, Functions and more

need a variable wrt to other variable

Reply
Contributor
Posts: 60

need a variable wrt to other variable

[ Edited ]

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

 

 

Super Contributor
Posts: 440

Re: need a variable wrt to other variable

Posted in reply to india2016

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;

 

 

Super User
Super User
Posts: 7,975

Re: need a variable wrt to other variable

Posted in reply to india2016
proc sort data=have;
  by descending time_stamp;
run;
data want;
  set have;
  if _n_=1;
run;
Ask a Question
Discussion stats
  • 2 replies
  • 105 views
  • 0 likes
  • 3 in conversation