數學之路-sas備忘(17)

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

2014-05-18

20140518

2014.05.18

2014/05/18

NOTE: “DATA 語句”所用時間（總處理時間）:

      實際時間          0.03 秒

      CPU 時間          0.01 秒

短日期格式 

data  _null_;

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

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/

data _null_;

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

-------------------------