topic Finding the minimum time value among a list of variables in SAS Programming

Finding the minimum time value among a list of variables

Maisha_Huq — Fri, 23 Oct 2015 14:46:23 GMT

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!!

Re: Finding the minimum time value among a list of variables

JoshB — Fri, 23 Oct 2015 15:02:50 GMT

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;

Re: Finding the minimum time value among a list of variables

DartRodrigo — Fri, 23 Oct 2015 15:13:26 GMT

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