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_;
55 a='2327:56:34't;
56 put a time8.2;
57 run;
2327:56
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:
>Thanks Toby,
>
>But it will fail if the hour part is too big:
>
>34 data _null_;
>35 a='2327:56:34't;
>36 put a time6.2;
>37 run;
>
> 2327
>
>-----Original Message-----
>From: toby dunn [mailto:tobydunn@hotmail.com]
>Sent: Thursday, October 25, 2007 9:42 AM
>To: Huang, Ya; sas-l@listserv.uga.edu
>Subject: RE: A time5. format but hold more than 24 hours ?
>
>
>Ya ,
>
>Time6.2
>
>
>Toby Dunn
>
>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;
>>
>>
>> 126
>> 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 ?
>>
>> Thanks
>>
>> Ya
>
>_________________________________________________________________
>Windows Live Hotmail and Microsoft Office Outlook - together at last. Get
it now.
>http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?
pid=CL100626971033
| 
