📄 m30 - transforming data with sas functions - 94 of 95.mht
字号:
numeric values when creating the variable =
<CODE>TargetNo</CODE>?<!-- InstanceEndEditable -->=20
<P>
<TABLE border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Da name=3Dques3> </TD>
<TD> <EM>a.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q3a" --><TT><FONT=20
=
color=3D#003399>TargetNo=3Dinput(target,comma6.);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Db name=3Dques3> </TD>
<TD> <EM>b.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q3b" --><TT><FONT=20
=
color=3D#003399>TargetNo=3Dinput(target,comma7.);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dc name=3Dques3> </TD>
<TD> <EM>c.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q3c" --><TT><FONT=20
=
color=3D#003399>TargetNo=3Dput(target,comma6.);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dd name=3Dques3> </TD>
<TD> <EM>d.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q3d" --><TT><FONT=20
=
color=3D#003399>TargetNo=3Dput(target,comma7.);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q4text" -->A typical =
value for the=20
numeric variable <CODE>SiteNum</CODE> is <EM>12.3</EM>. Which =
statement=20
correctly converts the values of <CODE>SiteNum</CODE> to =
character=20
values when creating the variable <CODE>Location</CODE>?<!-- =
InstanceEndEditable -->=20
<P>
<TABLE border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Da name=3Dques4> </TD>
<TD> <EM>a.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q4a" --><TT><FONT=20
=
color=3D#003399>Location=3Ddept||'/'||input(sitenum,3.1);</FONT></TT><!--=
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Db name=3Dques4> </TD>
<TD> <EM>b.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q4b" --><TT><FONT=20
=
color=3D#003399>Location=3Ddept||'/'||input(sitenum,4.1);</FONT></TT><!--=
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dc name=3Dques4> </TD>
<TD> <EM>c.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q4c" --><TT><FONT=20
=
color=3D#003399>Location=3Ddept||'/'||put(sitenum,3.1);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dd name=3Dques4> </TD>
<TD> <EM>d.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q4d" --><TT><FONT=20
=
color=3D#003399>Location=3Ddept||'/'||put(sitenum,4.1);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q5text" -->Suppose the =
YEARCUTOFF=3D=20
system option is set to 1920. Which MDY function creates the =
date value=20
for January 3, 2020?<!-- InstanceEndEditable -->=20
<P>
<TABLE border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Da name=3Dques5> </TD>
<TD> <EM>a.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q5a" --><TT><FONT=20
color=3D#003399>MDY(1,3,20)</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Db name=3Dques5> </TD>
<TD> <EM>b.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q5b" --><TT><FONT=20
color=3D#003399>MDY(3,1,20)</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dc name=3Dques5> </TD>
<TD> <EM>c.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q5c" --><TT><FONT=20
color=3D#003399>MDY(1,3,2020)</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dd name=3Dques5> </TD>
<TD> <EM>d.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q5d" --><TT><FONT=20
color=3D#003399>MDY(3,1,2020)</FONT></TT><!-- =
InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q6text" -->The variable=20
<CODE>Address2</CODE> contains values such as <EM>Piscataway, =
NJ</EM>.=20
How do you assign the two-letter state abbreviations to a new =
variable=20
named <CODE>State</CODE>?<!-- InstanceEndEditable -->=20
<P>
<TABLE border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Da name=3Dques6> </TD>
<TD> <EM>a.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q6a" --><TT><FONT=20
color=3D#003399>State=3Dscan(address2,2);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Db name=3Dques6> </TD>
<TD> <EM>b.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q6b" --><TT><FONT=20
=
color=3D#003399>State=3Dscan(address2,13,2);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dc name=3Dques6> </TD>
<TD> <EM>c.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q6c" --><TT><FONT=20
=
color=3D#003399>State=3Dsubstr(address2,2);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dd name=3Dques6> </TD>
<TD> <EM>d.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q6d" --><TT><FONT=20
=
color=3D#003399>State=3Dsubstr(address2,13,2);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q7text" -->The variable=20
<CODE>IDCode </CODE>contains values such as <EM>123FA</EM> and=20
<EM>321MB</EM>. The fourth character identifies sex. How do you =
assign=20
these character codes to a new variable named =
<CODE>Sex</CODE>?<!-- InstanceEndEditable -->=20
<P>
<TABLE border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Da name=3Dques7> </TD>
<TD> <EM>a.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q7a" --><TT><FONT=20
color=3D#003399>Sex=3Dscan(idcode,4);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Db name=3Dques7> </TD>
<TD> <EM>b.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q7b" --><TT><FONT=20
color=3D#003399>Sex=3Dscan(idcode,4,1);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dc name=3Dques7> </TD>
<TD> <EM>c.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q7c" --><TT><FONT=20
color=3D#003399>Sex=3Dsubstr(idcode,4);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dd name=3Dques7> </TD>
<TD> <EM>d.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q7d" --><TT><FONT=20
color=3D#003399>Sex=3Dsubstr(idcode,4,1);</FONT></TT><!-- =
InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q8text" -->Due to growth =
within the=20
919 area code, the telephone exchange 555 is being reassigned to =
the 920=20
area code. The data set <STRONG>Clients.Piedmont</STRONG> =
includes the=20
variable <CODE>Phone</CODE>, which contains telephone numbers in =
the=20
form <EM>919-555-1234</EM>. Which of the following programs will =
correctly change the values of <CODE>Phone</CODE>?<!-- =
InstanceEndEditable -->=20
<P>
<TABLE border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Da name=3Dques8> </TD>
<TD> <EM>a.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q8a" --><PRE><FONT =
color=3D#003399>data work.piedmont(drop=3Dareacode exchange);
set clients.piedmont;
Areacode=3Dsubstr(phone,1,3);
Exchange=3Dsubstr(phone,5,3);
if areacode=3D'919' and exchange=3D'555'
then scan(phone,1,3)=3D'920';
run;</FONT>
</PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Db name=3Dques8> </TD>
<TD> <EM>b.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q8b" --><PRE><FONT =
color=3D#003399>data work.piedmont(drop=3Dareacode exchange);
set clients.piedmont;
Areacode=3Dsubstr(phone,1,3);
Exchange=3Dsubstr(phone,5,3);
if areacode=3D'919' and exchange=3D'555'
then phone=3Dscan('920',1,3);
run;</FONT>
</PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dc name=3Dques8> </TD>
<TD> <EM>c.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q8c" --><PRE><FONT =
color=3D#003399>data work.piedmont(drop=3Dareacode exchange);
set clients.piedmont;
Areacode=3Dsubstr(phone,1,3);
Exchange=3Dsubstr(phone,5,3);
if areacode=3D'919' and exchange=3D'555'
then substr(phone,1,3)=3D'920';
run;</FONT>
</PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dd name=3Dques8> </TD>
<TD> <EM>d.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q8d" --><PRE><FONT =
color=3D#003399>data work.piedmont(drop=3Dareacode exchange);
set clients.piedmont;
Areacode=3Dsubstr(phone,1,3);
Exchange=3Dsubstr(phone,5,3);
if areacode=3D'919' and exchange=3D'555'
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -