设为首页 加入收藏

TOP

数学之路-sas备忘(16)(一)
2015-07-24 11:10:30 来源: 作者: 【 】 浏览:2
Tags:数学 -sas 备忘
data _null_;
mydate ='7MAR13'd;
put mydate YYMMDDP10.;
put mydate YYMMDDN8.;
put mydate YYMMDDC10.;
put mydate YYMMDDS10.;
put mydate YYMMDD10.;
put mydate WEEKDATE.;
put mydate WORDDATE.;
run;
2013.03.07
20130307
2013:03:07
2013/03/07
2013-03-07
? ? ? Thursday, March 7, 2013
? ? ?March 7, 2013
NOTE: “DATA 语句”所用时间(总处理时间):
? ? ? 实际时间 ? ? ? ? ?0.01 秒
? ? ? CPU 时间 ? ? ? ? ?0.01 秒
?
?
==============
?
data _null_;
mytime ='17:25:38't;
put mytime HHMM.;
put mytime TIME.;
put mytime TIMEAMPM.;
put mytime HOUR.;
put mytime TOD.;
run;
?
?
?
?
?
?
?
?
?
17:26
17:25:38
?5:25:38 PM
17
17:25:38
?
?
?
data _null_;
now=datetime();
put now DATEAMPM.;
put now DATETIME.;
put now nldatm.;
run;
?
?
?
30MAR15:03:12:14 PM
30MAR15:15:12:14
2015年03月30日 15时12分14秒
?
?
?
?
?
data _null_;
now=date();
put now YEAR.;
put now MONTH.;
put now DAY.;
run;
?
2015
?3
30
NOTE: “DATA 语句”所用时间(总处理时间):
? ? ? 实际时间 ? ? ? ? ?0.00 秒
? ? ? CPU 时间 ? ? ? ? ?0.00 秒
?
?
?
data _null_;
/*当前日期及时间*/
now=date();
put now YEAR.;
put now MONTH.;
put now DAY.;
put now=nldate.;
t1=time();
put t1=time.;
put t1=nltimap15.;
d1=today();
put d1=nldate.;
d2=today();
put d2=nldate.;
?
?
run;
?
?
?
2015
?3
30
now=2015年03月30日
t1=15:21:50
t1=下午03:21:50
d1=2015年03月30日
d2=2015年03月30日
NOTE: “DATA 语句”所用时间(总处理时间):
? ? ? 实际时间 ? ? ? ? ?0.01 秒
? ? ? CPU 时间 ? ? ? ? ?0.01 秒

?

Writes datetime values in the form ddmmmyy:hh:mm:ss.ss.

Category: Date and Time
Alignment: Right
Restriction: If w–d< 17, SAS truncates the decimal values.
Interaction: When the DECIMALCONV= system option is set to STDIEEE, the output that is written using this format might differ slightly from previous releases. For more information, see DECIMALCONV= System Option in SAS System Options: Reference.

Syntax

DATETIMEw.d
Syntax Description

w

specifies the width of the output field.

Default 16
Range 7–40
Tip SAS requires a minimum w value of 16 to write a SAS datetime value with the date, hour, and seconds. Add an additional two places to w and a value to d to return values with optional decimal fractions of seconds.

d

specifies the number of digits to the right of the decimal point in the seconds value. This argument is optional.

Range 0–39
Requirement must be less than w

Details

The DATETIMEw.d format writes SAS datetime values in the form ddmmmyy:hh:mm:ss.ss: ddis an integer that represents the day of the month. mmm is the first three letters of the month name. yyis a two-digit integer that represents the year. hhis an integer that represents the hour in 24–hour clock time. mmis an integer that represents the minutes. ss.ssis the number of seconds to two decimal places.

Example

The example table uses the input value of 1668138559, which is the SAS datetime value that corresponds to 3:49:19 a.m. on November 10, 2012.
SAS Statement Result
?
 
----+----1----+----2----+
put event datetime.;
10NOV12:03:49:19
put event datetime7.;
10NOV12
put event datetime12.;
  10NOV12:03
put event datetime18.;
  10NOV12:03:49:19
put event datetime18.1;
10NOV12:03:49:19.0
put event datetime19.;
 10NOV2012:03:49:19
put event datetime20.1;
10NOV2012:03:49:19.
首页 上一页 1 2 下一页 尾页 1/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇sqoop导入时删除string类型字段的.. 下一篇【MongoDB】windows下搭建Mongo主..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·数据库:推荐几款 Re (2025-12-25 12:17:11)
·如何最简单、通俗地 (2025-12-25 12:17:09)
·什么是Redis?为什么 (2025-12-25 12:17:06)
·对于一个想入坑Linux (2025-12-25 11:49:07)
·Linux 怎么读? (2025-12-25 11:49:04)