📄 m25 - creating a single observation from multiple records - 19 of 20.mht
字号:
<TD noWrap align=3Dleft bgColor=3D#f7f7de><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
size=3D2>1---+----10---+----20---</FONT></TD></TR></THEAD>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>LAWRENCE CALDWELL </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>1010</FONT><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2> LAKE STREET </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>ANAHEIM</FONT><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
size=3D2> CA 94122 </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>RACHEL CHEVONT </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>3719</FONT><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2> OLIVE VIEW ROAD </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>HARTFORD CT 06183 </FONT></TD></TR></TBODY></TABL=
E><!-- InstanceEndEditable -->
<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" --><PRE><FONT =
color=3D#003399>input Fname $ Lname $ /
Address $20. /=20
City $ State $ Zip $;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>input Fname $ Lname $ /;
Address $20. /;
City $ State $ Zip $;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>input / Fname $ Lname $
/ Address $20.
City $ State $ Zip $;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>input / Fname $ Lname $;
/ Address $20.;
City $ State $ Zip $;</FONT></PRE><!-- InstanceEndEditable =
--></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q5text" -->Which INPUT =
statement=20
correctly reads the values for <CODE>ID</CODE> in the fourth =
record,=20
then returns to the first record to read the values for=20
<CODE>Fname</CODE> and <CODE>Lname</CODE>?<BR><BR>
<TABLE title=3D"Raw Data File" cellSpacing=3D0 cellPadding=3D0 =
rules=3Dnone=20
bgColor=3D#cccccc border=3D1 frame=3Dbox>
<THEAD>
<TR>
<TD noWrap align=3Dleft bgColor=3D#f7f7de><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
size=3D2>1---+----10---+----20---</FONT></TD></TR></THEAD>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>GEORGE CHESSON </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>3801</FONT><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2> WOODSIDE COURT </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>GARNER NC 27529 </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>XM065 FLOYD </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>JAMES COLDWELL </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>123-A</FONT><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2> TARBERT </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>APEX NC 27529 </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>XMO65 LAWSON </FONT></TD></TR></TBODY></TABLE><BR><!--=
InstanceEndEditable -->
<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" --><PRE><FONT =
color=3D#003399>input #4 ID $5.=20
#1 Fname $ Lname $;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>input #4 ID $ 1-5=20
#1 Fname $ Lname $;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>input #4 ID $=20
#1 Fname $ Lname $;</FONT></PRE><!-- 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" -->all of the =
above<!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q6text" -->How many =
records will be=20
read for each execution of the DATA step?<BR><BR>
<TABLE title=3D"Raw Data File" cellSpacing=3D0 cellPadding=3D0 =
rules=3Dnone=20
bgColor=3D#cccccc border=3D1 frame=3Dbox>
<THEAD>
<TR>
<TD noWrap align=3Dleft bgColor=3D#f7f7de><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
size=3D2>1---+----10---+----20---</FONT></TD></TR></THEAD>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>SKIRT BLACK </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>COTTON </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>036499 $44.98 </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>SKIRT NAVY </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>LINEN </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>036899 $51.50 </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>DRESS RED </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>SILK</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>037299</FONT><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2> $76.98 </FONT></TD></TR></TBODY></TABLE><PRE><FONT =
color=3D#003399>data spring.sportswr;
infile newitems; =20
input #1 Item $ Color $
#3 @8 Price comma6.
#2 Fabric $
#3 SKU $ 1-6;
run; </FONT></PRE><!-- InstanceEndEditable -->
<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" -->one<!-- =
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" -->two<!-- =
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" -->three<!-- =
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" -->four<!-- =
InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q7text" -->Which INPUT =
statement=20
correctly reads the values for <CODE>City</CODE>, =
<CODE>State</CODE>,=20
and <CODE>Zip</CODE>?<BR><BR>
<TABLE title=3D"Raw Data File" cellSpacing=3D0 cellPadding=3D0 =
rules=3Dnone=20
bgColor=3D#cccccc border=3D1 frame=3Dbox>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -