SAS日期及时间格式
data _null_;
input mydate YYMMDD10.;
put mydate YYMMDDB10.;
put mydate YYMMDDC10.;
put mydate YYMMDDD10.;
put mydate YYMMDDN8.;
put mydate YYMMDDP10.;
put mydate YYMMDDS10.;
cards;
2014-05-18
;
run;
本博客全部内容是原创,假设转载请注明来源
http://blog.csdn.net/myhaspl/
2014:05:18
2014-05-18
20140518
2014.05.18
2014/05/18
NOTE: “DATA 语句”所用时间(总处理时间):
实际时间 0.03 秒
CPU 时间 0.01 秒
短日期格式
input mydate YYMMDD10.;
put mydate YYMMDDB8.;
put mydate YYMMDDC8.;
put mydate YYMMDDD8.;
put mydate YYMMDDN7.;
put mydate YYMMDDP8.;
put mydate YYMMDDS8.;
cards;
2014-05-18
;
run;
14:05:18
14-05-18
140518
14.05.18
14/05/18
NOTE: “DATA 语句”所用时间(总处理时间):
实际时间 0.00 秒
CPU 时间 0.00 秒
Writes SAS date values in the form <yy>yymmdd or <yy>yy-mm-dd, where the x in the format name is a character that represents the special character that separates the year, month, and day. The special character can be a hyphen (–), period (.), blank character, slash (/), colon (:), or no separator; the year can be either 2 or 4 digits.
Syntax
YYMMDDxw.
Arguments
x
identifies a separator or specifies that no separator appear between the year, the month, and the day. Here are the valid values:
B
separates with a blank
C
separates with a colon
D
separates with a hyphen
N
indicates no separator
P
separates with a period
S
separates with a slash.
w
specifies the width of the output field.
Default
8
Range
2–10
Interactions
When w has a value of from 2 to 5, the date appears with as much of the year and the month. When w is 7, the date appears as a two-digit year without separators.
When x has a value of N, the width range is 2–8.
Details
The YYMMDDxw. format writes SAS date values in the form <yy>yymmdd or <yy>yyXmmXdd. Here is an explanation of the syntax:
<yy>yy
is a two-digit or four-digit integer that represents the year.
X
is a specified separator.
mm
is an integer that represents the month.
dd
is an integer that represents the day of the month.
Comparisons
•
The YYMMDDw.d format is similar to the YYMMDDxw.d format, but YYMMDDxw.d format contains a separator between the year and month, such as a colon, slash, or period.
Example
The following examples use the input value of 18922, which is the SAS date value that corresponds to October 22, 2011.
Statements
Results
----+----1----+
a=put(18922,yymmddc5.);
11:10
a=put(18922,yymmddd8.);
11-10-22
a=put(18922,yymmddn8.);
20111022
a=put(18922,yymmddp10.);
2011.10.22
本博客全部内容是原创,假设转载请注明来源
http://blog.csdn.net/myhaspl/
mydate=date();
y=year(mydate);
m=month(mydate);
d=day(mydate);
qtr=qtr(mydate);
put mydate YYMMDD10.;
put y;
put m;
put d;
put qtr;
mytime=time();
put mytime TIME.;
h=hour(mytime);
mm=minute(mytime);
put h;
put mm;
put "====";
mydt=datetime();
put mydt DATETIME21.;
mm=minute(mydt);
hh=hour(mydt);
ss=second(mydt);
put hh;
put mm;
put ss;
run;
2015-04-01
2015
4
1
2
11:21:37
11
21
====
01APR2015:11:21:37
11
21
37.372999907
版权声明:本文博主原创文章,博客,未经同意不得转载。