📄 m27 - reading hierarchical files - 29 of 30.mht
字号:
for=20
<CODE>Fruit</CODE>, <CODE>Variety</CODE>, and =
<CODE>Price</CODE>=20
are written to the data set as the fourth observation. =
<!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q6text" -->Which SAS =
statement=20
indicates that several other statements should be executed when=20
<CODE>Record</CODE> has a value of <EM>A</EM>?<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 =
size=3D2>1---+----10---+----20---+----30</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>A 124153-01 </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>C $153.02 </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>D $20.00 </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>D $20.00</FONT></TD></TR></TBODY></TABLE><!-- =
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" --><PRE><FONT =
color=3D#003399>if record=3D'A' then do;</FONT></PRE><!-- =
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" --><PRE><FONT =
color=3D#003399>if record=3DA then do; </FONT></PRE><!-- =
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" --><PRE><FONT =
color=3D#003399>if record=3D'A' then;</FONT></PRE><!-- =
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" --><PRE><FONT =
color=3D#003399>if record=3DA then; </FONT> </PRE><!-- =
InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q7text" -->Which is true =
for the=20
following statements (X indicates a header record)? <PRE><FONT =
color=3D#003399>if code=3D'X' then do;
if _n_ > 1 then output;
Total=3D0;
input Name $ 3-20;
end;</FONT></PRE><!-- 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" --><TT>_N_</TT> =
equals=20
the number of times the DATA step has begun to =
execute.<!-- 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" -->When =
<TT><FONT=20
color=3D#003399>code=3D'X'</FONT></TT> and <TT><FONT =
color=3D#003399>_n_=20
> 1</FONT></TT> are true, an OUTPUT statement is =
executed. <!-- 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" -->Each header =
record=20
causes an observation to be written to the data set. <!-- =
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" --><EM>a</EM> =
and=20
<EM>b</EM><!-- InstanceEndEditable =
--></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q8text" -->What happens =
when the=20
condition <FONT color=3D#003399><TT>type=3D'P'</TT></FONT> is =
false? <PRE><FONT color=3D#003399>if type=3D'P' then input @3 ID $5. @9 =
Address $20.;=20
else if type=3D'V' then input @3 Charge 6.; </FONT></PRE><!-- =
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" -->The values =
for=20
<CODE>ID</CODE> and <CODE>Address</CODE> are read.<!-- =
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" -->The values =
for=20
<CODE>Charge</CODE> are read.<!-- 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" =
--><CODE>type</CODE> is=20
assigned the value of=20
<EM>V</EM>.<!-- 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" -->The ELSE =
statement is=20
executed. <!-- InstanceEndEditable =
--></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q9text" -->What happens =
when=20
<CODE>last</CODE> has a value other than zero? <PRE> =
<FONT color=3D#003399>data perm.househld (drop=3Dcode);=20
infile citydata end=3Dlast;=20
retain Address;=20
input type $1. @;=20
if code=3D'A' then do;=20
if _n_ > 1 then output;=20
Total=3D0; =20
input address $ 3-17;=20
end;=20
else if code=3D'N' then total+1;=20
if last then output;=20
run;</FONT></PRE><!-- 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" =
--><CODE>last</CODE> has=20
a value of <EM>1</EM>.<!-- 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" -->The OUTPUT =
statement=20
writes the last observation to the data set. <!-- =
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" -->The current =
value of=20
<CODE>last</CODE> is written to the DATA set.<!-- =
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" --><EM>a</EM> =
and=20
<EM>b</EM><!-- InstanceEndEditable =
--></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q10text" -->Based on the =
values in=20
the program data vector, what happens next?<BR><BR><IMG =
height=3D57=20
alt=3D"Program Data Vector containing 7 fields: _n_ contains 5, =
last contains 0, Department contains 'Accounting', Extension contains =
'x3808', type contains 'D', Total contains 16.50, Amount contains a =
period (missing)."=20
=
src=3D"http://www.sas.com/apps/OLTRN/59080/m27/images/m27qzg5.gif"=20
width=3D410> <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 =
size=3D2>1---+----10---+----20---+----30</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>D Accounting x3808</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>S Paper Clips $2.50</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>S Paper $4.9=
5</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>S Binders $9.05</FONT></=
TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>D Personnel x3810</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>S Markers $8.98</FONT></=
TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -