Date:         Tue, 26 Nov 2002 09:28:05 -0500
Reply-To:     Ian Whitlock <WHITLOI1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ian Whitlock <WHITLOI1@WESTAT.COM>
Subject:      Re: Conversion of time - Europe - Asia
Comments: To: "Howard_Schreier@ITA.DOC.GOV" <Howard_Schreier@ITA.DOC.GOV>
Comments: cc: "chuaby@HOTMAIL.COM" <chuaby@HOTMAIL.COM>
Content-Type: text/plain; charset="iso-8859-1"

Howard,

I agree with the spirit of not using raw arithmetic, but there are times
when I weaken.

12      data _null_;
13      Paris_datetime = '26NOV02:23:14:30'DT;
14      Singapore_datetime = intnx('hour',Paris_datetime,7);
15      put Paris_datetime=datetime. / Singapore_datetime=datetime.;
16      put "========================" ;
17      Singapore_datetime = Paris_datetime + 3600 * 7 ;
18      put Paris_datetime=datetime. / Singapore_datetime=datetime.;
19      run;

Paris_datetime=26NOV02:23:14:30
Singapore_datetime=27NOV02:06:00:00
========================
Paris_datetime=26NOV02:23:14:30
Singapore_datetime=27NOV02:06:14:30
NOTE: DATA statement used:
      real time           0.04 seconds

Then there is the more compromising

   Singapore_datetime = Paris_datetime + hms(7,0,0) ;

if one hasn't already moved on to other problems.

It is a shame that there is not a parameter for INTNX to move forward a
given amount.  I know that "months" cause problems, but I would think it
better to chose, document and have a parameter than leave it to crude tools.

IanWhitlock@westat.com

-----Original Message-----
From: Howard_Schreier@ITA.DOC.GOV [mailto:Howard_Schreier@ITA.DOC.GOV]
Sent: Tuesday, November 26, 2002 8:59 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Conversion of time - Europe - Asia


Use the INTNX function.

   data _null_;
   Paris_datetime = '26NOV02:23:00:00'DT;
   Singapore_datetime = intnx('hour',Paris_datetime,7);
   put Paris_datetime=datetime. / Singapore_datetime=datetime.;
   run;

Result:

   Paris_datetime=26NOV02:23:00:00
   Singapore_datetime=27NOV02:06:00:00


On Mon, 25 Nov 2002 23:20:56 -0800, chuaby <chuaby@HOTMAIL.COM> wrote:

>Hi
>
>I have a datetime field in Paris datetime which i need to convert it
>back to local datetime. May i know is there a function can i use to
>take in daylight saving into consideration ?
>
>eg : time difference between Paris and Singapore is 7 hrs now
>I would like Paris datetime = '26NOV02:23:00:00'DT
>to be Singapore datetime = '27NOV02:06:00:00'DT
>
>
>Thanks
>Boon Yiang