📄 m25 - creating a single observation from multiple records - 19 of 20.mht
字号:
<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>DINA =
FIELDS </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>904</FONT><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2> MAPLE =20
CIRCLE </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>DURHAM</FONT><FONT=20
face=3D"Courier New, Courier" color=3D#000000 =
size=3D2> NC =20
27713 </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>ELIZABETH =
GARRISON </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>1293 OAK =
AVENUE</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>CHAPEL HILL NC =
27614</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>DAVID</FONT><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2> =
HARRINGTON </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff>
<P><FONT face=3D"Courier New, Courier" color=3D#000000=20
size=3D2>2426 ELMWOOD LANE</FONT><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
size=3D2> </FONT></P></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier, mono" color=3D#000000 =
size=3D2>RALEIGH=20
NC 27803</FONT> </TD></TR></TBODY></TABLE><!-- =
InstanceEndEditable -->
<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" --><PRE><FONT =
color=3D#003399>input #3 City $ State $ Zip $; </FONT></PRE><!-- =
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" --><PRE><FONT =
color=3D#003399>input #3 City & $11. State $ Zip $;</FONT></PRE><!-- =
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" --><PRE><FONT =
color=3D#003399>input #3 City $11. +2 State $2. + 2 Zip =
$5.;</FONT></PRE><!-- 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" -->all of the =
above<!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q8text" -->Which program =
does=20
<B>not</B> read the values in the first record as a variable =
named=20
<CODE>Item</CODE> and the values in the second record as two =
variables=20
named <CODE>Inventory</CODE> and <CODE>Type</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>COLORED PENCILS </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>12 BOXES </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>WATERCOLOR PAINT </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>8 PALETTES </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>DRAWING PAPER </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>15 PADS </FONT></TD></TR></TBODY></TABLE><!-- =
InstanceEndEditable -->
<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 perm.supplies;
infile instock pad;
input Item & $16. /
Inventory 2. Type $8.;
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 perm.supplies;
infile instock pad;
input Item & $16.
/ Inventory 2. Type $8.;
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 perm.supplies;
infile instock pad;
input #1 Item & $16.
Inventory 2. Type $8.;
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 perm.supplies; =20
infile instock pad; =20
input Item & $16.
#2 Inventory 2. Type $8.;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q9text" -->Which INPUT =
statement=20
reads the values for <CODE>Lname,</CODE> <CODE>Fname,</CODE>=20
<CODE>Department</CODE> and <CODE>Salary</CODE> (in that =
order)?<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>ABRAMS THOMAS</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>SALES $25,209.03</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>BARCLAY ROBERT</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>MARKETING $29,180.36</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>COURTNEY MARK</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>PUBLICATIONS</FONT><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2> $24,006.16</FONT></TD></TR></TBODY></TABLE><!-- =
InstanceEndEditable -->
<P>
<TABLE border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Da name=3Dques9> </TD>
<TD> <EM>a.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q9a" --><PRE><FONT =
color=3D#003399>input #1 Lname $ Fname $ /</FONT>=20
<FONT color=3D#003399>Department $12. Salary comma10.;</FONT> =
</PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Db name=3Dques9> </TD>
<TD> <EM>b.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q9b" --><PRE><FONT =
color=3D#003399>input #1 Lname $ Fname $ /</FONT>=20
<FONT color=3D#003399>Department : $12. Salary : =
comma.;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dc name=3Dques9> </TD>
<TD> <EM>c.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q9c" --><PRE><FONT =
color=3D#003399>input #1 Lname $ Fname $</FONT>=20
<FONT color=3D#003399>#2 Department : $12. Salary : =
comma.;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dd name=3Dques9> </TD>
<TD> <EM>d.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q9d" --><FONT=20
color=3D#000000>both <EM>b</EM> and <EM>c</EM></FONT><!-- =
InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q10text" -->Which raw =
data file=20
poses potential problems when you are reading multiple records =
for each=20
observation?<!-- InstanceEndEditable -->=20
<P>
<TABLE border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Da name=3Dques10> </TD>
<TD> <EM>a.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q10a" -->
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -