数学之路-sas备忘(16)

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;

本博客所有内容是原创，如果转载请注明来源

http://blog.youkuaiyun.com/myhaspl/

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