SAS中文论坛
标题:
跟crakman做sas base认证试题（16）-补充内容
[打印本页]
作者:
shiyiming
时间:
2010-11-11 10:11
标题:
跟crakman做sas base认证试题（16）-补充内容
From crackman's blog on Baidu
<table border="1" cellspacing="0" cellpadding="6">
<caption align="top"><strong><em><a name="zenid-66">Tasks with Dates and Times, Part 2</a></em></strong></caption>
<tbody>
<tr valign="bottom" bgcolor="#cccccc">
<th valign="top" align="left"><strong>To do this ...</strong></th>
<th valign="top" align="left"><strong>Use this ...</strong></th>
<th valign="top" align="left"><strong>List</strong></th>
<th valign="top" align="left"><strong>Input</strong></th>
<th valign="top" align="left"><strong>Result</strong></th>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Date Tasks</td>
<td> </td>
<td valign="top" align="left"> </td>
<td valign="top" colspan="2" align="left"> </td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Read calendar dates as SAS date
<p>Note: YEARCUTOFF=1920</p>
</td>
<td valign="top" align="left">Date informats</td>
<td valign="top" align="left">DATE<strong>w.</strong></td>
<td valign="top" align="left">17MAR2000</td>
<td valign="top" align="left">-14534</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">DATE9.</td>
<td valign="top" align="left">17MAR2000</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">DDMMYY<strong>w.</strong></td>
<td valign="top" align="left">170300</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">DDMMYY8.</td>
<td valign="top" align="left">17032000</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">JULIAN<strong>w.</strong></td>
<td valign="top" align="left">0077</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">JULIAN7.</td>
<td valign="top" align="left">2000077</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">MMDDYY<strong>w.</strong></td>
<td valign="top" align="left">031700</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">MMDDYY10.</td>
<td valign="top" align="left">03172000</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">MONYY<strong>w.</strong></td>
<td valign="top" align="left">MAR00</td>
<td valign="top" align="left">14670</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">NENGO<strong>w.</strong></td>
<td valign="top" align="left">H.12/03/17</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">YYMMDD<strong>w.</strong></td>
<td valign="top" align="left">000317</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">YYMMDD10.</td>
<td valign="top" align="left">20000317</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">YYQ<strong>w.</strong></td>
<td valign="top" align="left">00Q1</td>
<td valign="top" align="left">14610</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Create date values from pieces</td>
<td valign="top" align="left">Date functions</td>
<td valign="top" align="left">DATEJUL</td>
<td valign="top" align="left">2000077</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">DHMS</td>
<td valign="top" align="left">'17MAR2000'D,
<p>00,00,00</p>
</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">HMS</td>
<td valign="top" align="left">14,45,32</td>
<td valign="top" align="left">53132</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">MDY</td>
<td valign="top" align="left">03,17,00</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">MDY</td>
<td valign="top" align="left">03,17,2000</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">YYQ</td>
<td valign="top" align="left">00,1</td>
<td valign="top" align="left">14610</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Extract a date from a datetime value</td>
<td valign="top" align="left">Date functions</td>
<td valign="top" align="left">DATEPART</td>
<td valign="top" align="left">'17MAR00:00:00
<p>'DT</p>
</td>
<td valign="top" align="left">14686</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Return today's date as a SAS date</td>
<td valign="top" align="left">Date functions</td>
<td valign="top" align="left">DATE() or TODAY() (equivalent)</td>
<td valign="top" align="left">( )</td>
<td valign="top" align="left">SAS date for today</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Extract calendar dates from SAS</td>
<td valign="top" align="left">Date functions</td>
<td valign="top" align="left">DAY</td>
<td valign="top" align="left">14686</td>
<td valign="top" align="left">17</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">HOUR</td>
<td valign="top" align="left">14686</td>
<td valign="top" align="left">4</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">JULDATE</td>
<td valign="top" align="left">14686</td>
<td valign="top" align="left">0077</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">JULDATE7</td>
<td valign="top" align="left">14686</td>
<td valign="top" align="left">2000077</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">MINUTE</td>
<td valign="top" align="left">14686</td>
<td valign="top" align="left">4</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">MONTH</td>
<td valign="top" align="left">14686</td>
<td valign="top" align="left">3</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">QTR</td>
<td valign="top" align="left">14686</td>
<td valign="top" align="left">3</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">SECOND</td>
<td valign="top" align="left">14686</td>
<td valign="top" align="left">46</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">WEEKDAY</td>
<td valign="top" align="left">14686</td>
<td valign="top" align="left">6</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">YEAR</td>
<td valign="top" align="left">14686</td>
<td valign="top" align="left">2000</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Write a date as a constant in an expression</td>
<td valign="top" align="left">SAS date constant</td>
<td valign="top" align="left"><strong>'ddmmmyy'</strong>d
<p>or</p>
<p><strong>'ddmmmyyyy'</strong></p>
</td>
<td valign="top" align="left">
<pre>'17mar00'd</pre>
<pre>'17mar2000'd</pre>
</td>
<td valign="top" align="left"><br>
<p> </p>
<p> </p>
<p> </p>
<p>14686</p>
</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Write today's date as a string</td>
<td valign="top" align="left">SYSDATE automatic macro variable</td>
<td valign="top" align="left">SYSDATE</td>
<td valign="top" align="left">&SYSDATE</td>
<td valign="top" align="left">Date at time of SAS initialization in DDMMMYY</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td valign="top" align="left">SYSDATE9</td>
<td valign="top" align="left">SYSDATE9</td>
<td valign="top" align="left">&SYSDATE9</td>
<td valign="top" align="left">Date at time of SAS initialization in DDMMMYYYY</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Time Tasks</td>
<td> </td>
<td valign="top" align="left"> </td>
<td valign="top" colspan="2" align="left"> </td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Write SAS time values as time values</td>
<td valign="top" align="left">time formats</td>
<td valign="top" align="left">HHMM.</td>
<td valign="top" align="left">53132</td>
<td valign="top" align="left">14:46</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">HOUR.</td>
<td valign="top" align="left">53132</td>
<td valign="top" align="left">15</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">MMSS.</td>
<td valign="top" align="left">53132</td>
<td valign="top" align="left">885</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">TIME.</td>
<td valign="top" align="left">53132</td>
<td valign="top" align="left">14:45:32</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left"> </td>
<td valign="top" align="left"> </td>
<td valign="top" align="left">TOD.</td>
<td valign="top" align="left">53132</td>
<td valign="top" align="left">14:45:32</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Read time values as SAS time values</td>
<td valign="top" align="left">Time informats</td>
<td valign="top" align="left">TIME</td>
<td valign="top" align="left">14:45:32</td>
<td valign="top" align="left">53132</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Write the current time as a string</td>
<td valign="top" align="left">SYSTIME automatic macro variable</td>
<td valign="top" align="left">SYSTIME</td>
<td valign="top" align="left">&SYSTIME</td>
<td valign="top" align="left">Time at moment of execution in HH:MM</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Return the current time of day as a SAS time value</td>
<td valign="top" align="left">Time functions</td>
<td valign="top" align="left">TIME( )</td>
<td valign="top" align="left">( )</td>
<td valign="top" align="left">SAS time value at moment of execution in NNNNN.NN</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Return the time part of a SAS datetime value</td>
<td valign="top" align="left">Time functions</td>
<td valign="top" align="left">TIMEPART</td>
<td valign="top" align="left">SAS datetime value in NNNNNNNNNN.N</td>
<td valign="top" align="left">SAS time value part of date value in NNNNN.NN</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Datetime Tasks</td>
<td> </td>
<td valign="top" align="left"> </td>
<td valign="top" colspan="2" align="left"> </td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Write SAS datetime values as datetime values</td>
<td valign="top" align="left">Datetime formats</td>
<td valign="top" align="left">DATEAMPM</td>
<td valign="top" align="left">1217083532</td>
<td valign="top" align="left">26JUL98:02:45 PM</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">DATETIME</td>
<td valign="top" align="left">1268870400</td>
<td valign="top" align="left">17MAR00:00:00
<p>:00</p>
</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td> </td>
<td> </td>
<td valign="top" align="left">EURDFDT</td>
<td valign="top" align="left">1217083532</td>
<td valign="top" align="left">26JUL98:14:45:32</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Read datetime values as SAS datetime values</td>
<td valign="top" align="left">Datetime informats</td>
<td valign="top" align="left">DATETIME</td>
<td valign="top" align="left">17MAR00:00:00:00</td>
<td valign="top" align="left">1268870400</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Return the current date and time of day as a SAS datetime value</td>
<td valign="top" align="left">Datetime functions</td>
<td valign="top" align="left">DATETIME()</td>
<td valign="top" align="left">()</td>
<td valign="top" align="left">SAS datetime value at moment of execution in NNNNNNNNNN.N</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Interval Tasks</td>
<td> </td>
<td valign="top" align="left"> </td>
<td valign="top" colspan="2" align="left"> </td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Return the number of specified time intervals that lie between the two date or datetime values</td>
<td valign="top" align="left">Interval functions</td>
<td valign="top" align="left">INTCK</td>
<td valign="top" align="left">week 2
<p>01aug60</p>
<p>01jan01</p>
</td>
<td valign="top" align="left">1055</td>
</tr>
<tr valign="top" bgcolor="#ffffff">
<td valign="top" align="left">Advances a date, time, or datetime value by a given interval, and returns a date, time, or datetime value</td>
<td valign="top" align="left">Interval functions</td>
<td valign="top" align="left">INTNX</td>
<td valign="top" align="left">day
<p>14086</p>
<p>01jan60</p>
</td>
<td valign="top" align="left">14086</td>
</tr>
</tbody>
</table>
<br>
The SAS System also supports international formats and informats that are equivalent to some of the most commonly used English-language date formats and informats. For details, see "SAS Formats" and "SAS Informats." <a href="http://hi.baidu.com/crack%5Fman/blog/item/9e76bbb3b60948e430add1d0.html">阅读全文</a>
<br/><b>类别：</b><a href="http://hi.baidu.com/crack%5Fman/blog/category/%B8%FAcrackman%D7%F6sas%20base%C8%CF%D6%A4%CA%D4%CC%E2">跟crackman做sas base认证试题</a> <a href="http://hi.baidu.com/crack%5Fman/blog/item/9e76bbb3b60948e430add1d0.html#comment">查看评论</a>
欢迎光临 SAS中文论坛 (https://mysas.net/forum/)
Powered by Discuz! X3.2