Date: Thu, 25 Oct 2007 12:52:17 -0400
Reply-To: Ya Huang <ya.huang@AMYLIN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ya Huang <ya.huang@AMYLIN.COM>
Subject: Re: A time5. format but hold more than 24 hours ?
Actually, Toby was right, I can use time8.2
54 data _null_;
56 put a time8.2;
So, the ':' here is like the decimal point in a number?
On Thu, 25 Oct 2007 09:48:58 -0700, Huang, Ya <Ya.Huang@AMYLIN.COM> wrote:
>But it will fail if the hour part is too big:
>34 data _null_;
>36 put a time6.2;
>From: toby dunn [mailto:firstname.lastname@example.org]
>Sent: Thursday, October 25, 2007 9:42 AM
>To: Huang, Ya; email@example.com
>Subject: RE: A time5. format but hold more than 24 hours ?
>Compromise is like telling a lie, it gets easier and easier. Each
compromise you make, that becomes your standard.
>Perfection doesnt exist, once you reach it, its not perfect anymore. It
means something else.
>> Date: Thu, 25 Oct 2007 12:32:32 -0400
>> From: ya.huang@AMYLIN.COM
>> Subject: A time5. format but hold more than 24 hours ?
>> To: SAS-L@LISTSERV.UGA.EDU
>> Hi there,
>> I want to show an elapse time as hh:mm format, but the hour part may
>> go over 24. For example, a='127:56:34't, I want it shown as 127:56. If
>> I use time5., I'll get 127.
>> I tried to play around the picture format, but failed:
>> 122 proc format;
>> 123 picture mytime
>> 124 low-high = '%0I:%0M' (datatype=time);
>> 125 run;
>> 127 data _null_;
>> 128 a='7:56:34't;
>> 129 put a time5. a mytime.;
>> 130 a='127:56:34't;
>> 131 put a time5. a mytime.;
>> 132 run;
>> 7:56 07:56
>> 127 07:56
>> I change to '%00I:%0M', but not work either. I can't use time7.,
>> because I don't want to see the second portion.
>> Any idea ?
>Windows Live Hotmail and Microsoft Office Outlook - together at last. Get