📄 m30 - transforming data with sas functions - 93 of 95.mht
字号:
in=20
which the function finds the string and returns a value greater =
than=20
<EM>0</EM> are written to the new data =
set.</TD></TR></TBODY></TABLE></CENTER>
<P align=3Dcenter>
<CENTER>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD align=3Dleft><STRONG>UPCASE Function</STRONG><BR>Lowercase =
letters in=20
character values can be <A=20
onmouseover=3D"window.status=3D'Display details on the UPCASE =
function.'; "=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_83.htm">converted to =
uppercase</A> by using the UPCASE function. Include the function =
in an=20
assignment statement, and specify the variable name in=20
parentheses.</TD></TR></TBODY></TABLE></CENTER>
<P align=3Dcenter>
<CENTER>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD><STRONG>LOWCASE Function</STRONG><BR>Uppercase letters in =
character=20
values can be <A=20
onmouseover=3D"window.status=3D'Display details on the LOWCASE =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_85.htm">converted to =
lowercase</A> by using the LOWCASE function. Include the function =
in an=20
assignment statement, and specify the variable name in=20
parentheses.</TD></TR></TBODY></TABLE></CENTER>
<P align=3Dcenter>
<CENTER>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD><STRONG>TRANWRD Function</STRONG><BR>You can replace or remove =
<A=20
onmouseover=3D"window.status=3D'Display details on the TRANWRD =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_87.htm">patterns of=20
characters</A> in the values of character variables by using the =
TRANWRD=20
function. Use the function in an assignment statement, and specify =
the=20
source, target, and replacement strings or variables in=20
parentheses.</TD></TR></TBODY></TABLE></CENTER>
<P align=3Dcenter>
<CENTER>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD><STRONG>INT Function</STRONG><BR>To return the integer portion =
of a=20
numeric value, use the <A=20
onmouseover=3D"window.status=3D'Display details on the INT =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_89.htm">INT=20
function</A>. Any decimal portion of the INT function argument is=20
discarded.</TD></TR></TBODY></TABLE></CENTER>
<P align=3Dcenter>
<CENTER>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD><STRONG>ROUND Function</STRONG><BR>To round values to the =
nearest=20
specified unit, use the <A=20
onmouseover=3D"window.status=3D'Display details on the ROUND =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_90.htm">ROUND=20
function</A>. If a round-off unit is not provided, the argument is =
rounded=20
to the nearest integer.</TD></TR></TBODY></TABLE><BR>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD><STRONG>Nesting SAS Functions</STRONG><BR>To write more =
efficient=20
programs, you can <A=20
onmouseover=3D"window.status=3D'Display details on the ROUND =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_92.htm">nest=20
functions</A> as appropriate.You can nest any functions as long as =
the=20
function that is used as the argument meets the requirements for =
the=20
argument.</TD></TR></TBODY></TABLE></CENTER><!-- =
InstanceEndEditable --><BR>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" align=3Dcenter =
border=3D0>
<TBODY>
<TR>
<TD align=3Dleft>
<HR>
</TD></TR></TBODY></TABLE>
<P><!-- InstanceBeginEditable name=3D"syntax" -->
<CENTER>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD><STRONG><A name=3DSyntax>Syntax</A></STRONG>=20
<P><EM>To go to the page where a statement or option was =
presented, select=20
a link.</EM>=20
<BLOCKQUOTE><A=20
onmouseover=3D"window.status=3D'Display details on the INPUT =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_11.htm"><STRONG>INPUT=
(</STRONG><EM>source,</EM><EM>informat</EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the PUT =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_19.htm"><STRONG>PUT(<=
/STRONG><EM>source,</EM><EM>format</EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the YEAR =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_28.htm"><STRONG>YEAR(=
</STRONG><EM>date</EM><STRONG>)</STRONG></A>  =
; =20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the QTR =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_28.htm"><STRONG>QTR(<=
/STRONG><EM>date</EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the MONTH =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_28.htm"><STRONG>MONTH=
(</STRONG><EM>date</EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the DAY =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_28.htm"><STRONG>DAY(<=
/STRONG><EM>date</EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the WEEKDAY =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_40.htm"><STRONG>WEEKD=
AY(</STRONG><EM>date</EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the MDY =
function.'; "=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_42.htm"><STRONG>MDY(<=
/STRONG><EM>month,day,year</EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the TODAY =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_46.htm"><STRONG>DATE(=
)</STRONG></A> =20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the TODAY =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_46.htm"><STRONG>TODAY=
()</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the INTCK =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_48.htm"><STRONG>INTCK=
(</STRONG>'<EM>interval</EM>',<EM>from</EM>,<EM>to</EM><STRONG>)</STRONG>=
</A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the INTNX =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_52.htm"><STRONG>INTNX=
(</STRONG>'<EM>interval</EM>',<EM>start-from</EM>,<EM>increment</EM><,=
'<EM>alignment</EM>'><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the SCAN =
function.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_56.htm"><STRONG>SCAN(=
</STRONG><EM>argument,n,<delimiters></EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on extracting =
values with the SUBSTR function.'; "=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_65.htm"><STRONG>SUBST=
R(</STRONG><EM>argument,position,<n></EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the TRIM =
function.'; "=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_75.htm"><STRONG>TRIM(=
</STRONG><EM>argument</EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the INDEX =
function.'; "=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_78.htm"><STRONG>INDEX=
(</STRONG><EM>source,excerpt</EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the UPCASE =
function.'; "=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_83.htm"><STRONG>UPCAS=
E(</STRONG><EM>argument</EM><STRONG>)</STRONG></A>=20
<P><A=20
onmouseover=3D"window.status=3D'Display details on the LOWCASE =
function.'; "=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m30/m30_85.htm"><STRONG>LOWCA=
SE(</STRONG><EM>argument</EM><STRONG>)</STRONG></A>=20
<P><A=20
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -