楼主: rockfido
2475 3

[问答] how to convernt character variable into datetime format [推广有奖]

  • 0关注
  • 0粉丝

已卖:1754份资源

博士生

32%

还不是VIP/贵宾

-

威望
0
论坛币
2715 个
通用积分
0.0341
学术水平
1 点
热心指数
1 点
信用等级
0 点
经验
4441 点
帖子
201
精华
0
在线时间
202 小时
注册时间
2008-8-29
最后登录
2024-11-1

楼主
rockfido 在职认证  发表于 2010-12-3 23:04:59 |AI写论文
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;
关键词:Character convernt datetime Variable format Variable format Character datetime convernt

本帖被以下文库推荐

沙发
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

板凳
crackman 发表于 2010-12-4 22:19:23
比较全面的解释了日期格式的问题

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注cda
拉您进交流群
GMT+8, 2025-12-6 04:57