Finding the minimum time value among a list of variables

[Maisha_Huq]

Hi!

Would anyone have a suggestion for which function to use to find the earliest time value from an array of variables?

I appreciate it!!

[JoshB]

Assuming you already have your array, called x

data want;
  set have;
  /* array x declaration */;
  do over x;
    min_date = min(of min_date,x);
  end;
/* or whatever date format you're working with */
  format min_date mmddyy10.; 
run;

[DartRodrigo]

Hi mate,

Try this:

data test;
 inv=101;  date2="02FEB1900 19:00"dt; date3="01JAN1890 11:22"DT; date4="09NOV2014 02:22"dt; 
 format date1-date4 datetime.;
run;

data want (drop=i);
 set test;
 array date{*} date:;
   mindate = min(of date{*});
   format mindate datetime20.;
run;

Hope this helps

Att