topic Extracting by minimum date for the group in SAS Data Management

Extracting by minimum date for the group

radhikaa4 — Wed, 12 Jul 2017 19:56:26 GMT

Hello. Here's the sample dataset and I am trying to extract only first occurence of the group BY date

Final output:

art297 — Wed, 12 Jul 2017 20:09:07 GMT

just instruct your code to do it:

data want;
  set have;
  by master_id;
  if first.master_id;
run;

Art, CEO, AnalystFinder.com

kiranv_ — Wed, 12 Jul 2017 20:12:29 GMT

something like should work

proc sql;
select * from have
group by master_id
having date =min(date);