首页 / MYSQL / 数学之路-sas备忘(16)
数学之路-sas备忘(16)
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了数学之路-sas备忘(16)，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含6713字，纯文字阅读大概需要10分钟。
内容图文
data _null_; mydate =7MAR13d; 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-
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.dSyntax 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.0 |
put event datetime21.2; |
10NOV2012:03:49:19.00 |
run;
30MAR2015:17:25:51.91
===============
DATETIMEw. Informat
Syntax
DATETIMEw.Syntax Description
w
specifies the width of the input field.
| Default | 18 |
| Range | 13–40 |
Details
The datetime values must be in the following form: ddmmmyy or ddmmmyyyy, followed by a blank or special character, followed by hh:mm:ss.ss (the time): dd is an integer between 01 and 31 that represents the day of the month. mmmis the first three letters of the month name. yy or yyyyis a two-digit or four-digit integer that represents the year. hh is an integer between 00 and 23 that represents hours. mmis an integer between 00 and 59 that represents minutes. ss.ss is the number of seconds ranging from 00–59 with the fraction of a second following the decimal point. DATETIMEw. requires values for both the date and the time. However, the ss.ss portion is optional. Note: SAS interprets a two-digit year as belonging to the 100-year span that is defined by the YEARCUTOFF= system option. Note: SAS can read time values with AM and PM in them.Comparisons
The DATETIMEw.d informat reads datetime values with optional separators in the form dd-mmm-yyExample
input date_and_time datetime20.;
| Data Line | Result |
|---|---|
----+----1----+----2 |
|
16mar12:11:23:07.4 |
1647516187.4 |
16mar2012/11:23:07.4 |
1647516187.4 |
16mar2012/11:23 PM |
1647559380.0 |
Writes SAS date values in the form
YYMMDDw.
Arguments
w
specifies the width of the output field.
| Default | 8 |
| Range | 2–10 |
| Interaction | When w has a value of from 2 to 5, the date appears with as much of the year and the month as possible. When w is 7, the date appears as a two-digit year without hyphens. |
Details
The YYMMDDw. format writes SAS date values in the formComparisons
The YYMMDDw.d format is similar to the YYMMDDxw.d format, except the YYMMDDxw.d format contains separators, such as a colon, slash, or period between the year, month, and day.Example
The following examples use the input value of 18720, which is the SAS date value that corresponds to April 3, 2011.| Statements | Results |
|---|---|
|
|
----+----1----+ |
a=put(18720,yymmdd2.); |
11 |
a=put(18720,yymmdd3.); |
11 |
a=put(18720,yymmdd4.); |
1104 |
a=put(18720,yymmdd5.); |
11-04 |
a=put(18720,yymmdd6.); |
110403 |
a=put(18720,yymmdd7.); |
110403 |
a=put(18720,yymmdd8.); |
11-04-03 |
a=put(18720,yymmdd10.); |
2011-04-03 |
内容总结
以上是互联网集市为您收集整理的数学之路-sas备忘(16)全部内容，希望文章能够帮你解决数学之路-sas备忘(16)所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。