Solved: Hi - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

Hi

Posted 03-27-2012 07:27 AM (1206 views)

my dataset like

date time
19910426 1123
;
run;
date and time are character

i want to get output like

datetime
1991Mar26:11:23:00

1 ACCEPTED SOLUTION

Accepted Solutions

Onyx | Level 15

Onyx | Level 15

Hi

Posted 03-27-2012 07:46 AM (1273 views) | In reply to sasemp999

data have;

input (date time) (:$);

cards;

19910426 1123

;

data want;

set have;

format dt datetime19.;

dt=dhms(input(date,yymmdd10.),0,0,input(time,b8601tm.));

put dt;

run;

Now, Do I get credit ?

View solution in original post

2 REPLIES 2

Onyx | Level 15

Onyx | Level 15

Hi

Posted 03-27-2012 07:46 AM (1274 views) | In reply to sasemp999

data have;

input (date time) (:$);

cards;

19910426 1123

;

data want;

set have;

format dt datetime19.;

dt=dhms(input(date,yymmdd10.),0,0,input(time,b8601tm.));

put dt;

run;

Now, Do I get credit ?

Calcite | Level 5

Calcite | Level 5

Hi

Posted 03-27-2012 08:02 AM (1130 views) | In reply to Haikuo

Thank U Hai.Kuo