topic Re: Date 20110503 09:58:47.65 in ODS and Base Reporting

Date 20110503 09:58:47.65

Filipvdr — Tue, 17 May 2011 15:02:16 GMT

Hello,

I have a date like this: 20110503 09:58:47.65 (String format $48).
How do I make this a Sas DateTime? ( the .65 can be dropped at the end )

Thanks! Message was edited by: Filipvdr

Re: Date 20110503 09:58:47.65

AndyJ — Tue, 17 May 2011 17:17:50 GMT

data sample_data;
infile datalines;
input original_variable $48.;
datalines;
20110503 09:58:47.65
;
run;

data modified_data;
set sample_data;

*** separate date from original string ***;
date=input(scan(original_variable,1,' '), yymmdd8.);

*** separate time from original string ***;
time=scan(original_variable,-1,' ');

*** separate out hours minutes and seconds ***;
hour=input(scan(time,1,':'),2.);
minute=input(scan(time,2,':'),2.);
second=input(scan(time,3,':'),2.);

*** create datetime variable ***;
datetime=dhms(date,hour,minute,second);

*** check work ***;
datetime2=put(datetime,datetime.);

run;

Re: Date 20110503 09:58:47.65

Filipvdr — Wed, 18 May 2011 07:05:47 GMT

ok thanks :) Message was edited by: Filipvdr

Re: Date 20110503 09:58:47.65

Ksharp — Thu, 19 May 2011 03:41:11 GMT

[pre]
options datestyle=ymd;
data sample_data;
infile datalines;
input original_variable anydtdtm22.;
format original_variable datetime20.;
datalines;
20110503 09:58:47.65
;
run;
[/pre]

Ksharp Message was edited by: Ksharp

Re: Date 20110503 09:58:47.65

sbb — Thu, 19 May 2011 13:56:51 GMT

I found that using ANYDTDTM INFORMAT is inconsistent and sometimes unpredictable - splitting the two date-time components for INPUT and then combining them with DHMS (without manual parsing) works well.

Scott Barry
SBBWorks, Inc.

1 data _null_;
2 infile datalines;
3 length tm_char $11;
4 input dt_char $ tm_char $;
5 dt = input(dt_char,yymmdd8.);
6 tm = input(tm_char,time11.);
7 dt_tm = dhms(dt,0,0,tm);
8 format dt_tm datetime22.2;
9 list;
10 putlog _all_;
11 datalines;

tm_char=09:58:47.65 dt_char=20110503 dt=18750 tm=35927.65 dt_tm=03MAY2011:09:58:47.65 _ERROR_=0
_N_=1
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+
12 20110503 09:58:47.65
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds

13 run;

Re: Date 20110503 09:58:47.65

Filipvdr — Fri, 20 May 2011 09:59:01 GMT

thanks for your research, i'm using that one now and it goes good!