how to convernt character variable into datetime format

rockfido

2438

收藏 2010-12-03

悬赏 20 个论坛币已解决

I have the character format value for one variable:

Date
2010-05-05 00:00:00

But I want to change it into datetime format. How can I do it?

I tried:

date_new = input(Date, YYMMDD10.) -- But this wont give me time information

I also tired:

date_new = input(Date, Datetime.) -- but failed...

Anyone can help me on it?

Thanks,

最佳答案

Bridgenc 查看完整内容

You can try this: data a; input datetime $30.; datalines; 2010-05-05 00:00:00 ; run; data b; set scan(datetime,2," "); format date mmddyy10. time TIME.; date=input(scan(datetime,1," "),yymmdd10.); time=input(scan(datetime,2," "),TIME.); run;

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

全部回复

Bridgenc

2010-12-3 23:05:00

You can try this:
data a;
input datetime $30.;
datalines;
2010-05-05 00:00:00
;
run;

data b;
set scan(datetime,2," ");
format date mmddyy10. time TIME.;
date=input(scan(datetime,1," "),yymmdd10.);
time=input(scan(datetime,2," "),TIME.);
run;

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

crackman

2010-12-4 22:19:08

http://crackman.net/?tag=%E6%97% ... F%E6%A0%BC%E5%BC%8F

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

crackman

2010-12-4 22:19:23

比较全面的解释了日期格式的问题

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

最佳答案

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

分享

扫码加好友，拉您进群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群