📄 m26 - creating multiple observations from a single record - 32 of 33.mht
字号:
<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>totalpay+1;</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>totalpay*1;</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>totalpay by 1;</FONT></PRE><!-- InstanceEndEditable =
--></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q9text" -->Which program =
creates=20
the SAS data set <STRONG>Perm.Topstore</STRONG> from the raw =
data file=20
shown below?<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 align=3Dmiddle bgColor=3D#f7f7de><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2><NOBR>1---+----10---+----20---+----30---+</NOBR></FONT></TD></TR=
></THEAD>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>1001 77,163.19 76,804.75=20
74,384.27</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>1002 76,612.93 81,456.34=20
82,063.97</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>1003 82,185.16=20
79,742.33</FONT></TD></TR></TBODY></TABLE><BR>SAS Data Set =
Perm.Topstore=20
<TABLE title=3D"SAS Data Set" cellSpacing=3D0 cellPadding=3D3 =
bgColor=3D#cccccc=20
border=3D1 frame=3Dbox>
<THEAD>
<TR>
<TD align=3Dmiddle bgColor=3D#f7f7de><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2><B>Store</B></FONT></TD>
<TD align=3Dmiddle bgColor=3D#f7f7de><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2><B>Sales</B></FONT></TD>
<TD align=3Dmiddle bgColor=3D#f7f7de><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2><B>Month</B></FONT></TD></TR></THEAD>
<TBODY>
<TR>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>1001</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>77163.19</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>1</FONT></TD></TR>
<TR>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>1001</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>76804.75</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>2</FONT></TD></TR>
<TR>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>1001</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>74384.27</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>3</FONT></TD></TR>
<TR>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>1002</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>76612.93</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>1</FONT></TD></TR>
<TR>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>1002</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>81456.34</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>2</FONT></TD></TR>
<TR>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>1002</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>82063.97</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>3</FONT></TD></TR>
<TR>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>1003</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>82185.16</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>1</FONT></TD></TR>
<TR>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>1003</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>79742.33</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>2</FONT></TD></TR></TBODY></TABLE><BR><!-- =
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>data perm.topstores;
infile sales98 missover;
input Store Sales : comma. @;
do while (sales ne .);
month + 1;
output;
input sales : comma. @;
end;
run;</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>data perm.topstores;
infile sales98 missover;
input Store Sales : comma. @;
do while (sales ne .);
Month=3D0;=20
month + 1;
output;
input sales : comma. @;
end;
run;</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>data perm.topstores;
infile sales98 missover;
input Store Sales : comma. Month @;=20
do while (sales ne .);
month + 1;
input sales : comma. @;
end;
output;
run;</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" --><PRE><FONT =
color=3D#003399>data perm.topstores;
infile sales98 missover;
input Store Sales : comma. @;
Month=3D0;=20
do while (sales ne .);
month + 1;
output;
input sales : comma. @;
end;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q10text" -->How many =
observations=20
are produced by the DATA step that reads this external =
file?<BR><BR>
<TABLE title=3D"Raw Data File" cellSpacing=3D0 cellPadding=3D0 =
rules=3Dnone=20
bgColor=3D#cccccc border=3D1 frame=3Dbox>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#f7f7de><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>1---+----10---+----20---+----30---+----40</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>01 CHOCOLATE VANILLA =
RASPBERRY</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>02 VANILLA PEACH</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>03 CHOCOLATE</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>04 RASPBERRY PEACH =
CHOCOLATE</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>05 STRAWBERRY VANILLA=20
CHOCOLATE</FONT></TD></TR></TBODY></TABLE><PRE><FONT =
color=3D#003399>data perm.choices;
infile icecream missover;
input Day $ Flavor : $10. @;=20
do while (flavor ne ' ');=20
output;
input flavor : $10. @;=20
end;
run; </FONT></PRE><!-- InstanceEndEditable -->
<P>
<TABLE border=3D0>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -