Date:         Fri, 31 May 2002 13:05:07 -0400
Reply-To:     PBourdages@IAG.QC.CA
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         PBourdages@IAG.QC.CA
Subject:      Time problem....
Content-Type: multipart/alternative;

I found out a problem with the following code... When I have records with
time period ranging from midnight and 1 seconds till 1:00 AM, the time get
mixed up somehoy...

proc format ;
  picture cnvtm low - high = "00:00:00" ;
run ;

data test1;
    input skip $ tm $ ;
    format tt time8.;
    time = input(put(input(tm,8.),cnvtm.),time8.);
    put time time8.;
    tt = time;
    Heure   = hour(tt);
    minute  = minute(tt);
    seconde = second(tt);
cards ;
20000101  93526
20000103 100511
20000106 175632
20020531    931
20020531   1931
;
dm "vt test1" continue;

When runned, the first three record are OK but the following two are messed
up... Why ?

They should return 00:09:31 and 00:19:31....

The hours stored in the real file are stored in numeric format like 235959
for 23:59:59. Is there a better way of doing this thing...

Sincerely yours,

Patrice Bourdages
Information Systems Analyst
Industrial Alliance, car and home insurance
(418) 650-4600 ext.3216



[text/html]