📄 m27 - reading hierarchical files - 29 of 30.mht
字号:
--></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Db name=3Dques2> </TD>
<TD> <EM>b.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q2b" --><PRE><FONT =
color=3D#003399>input code $2. @@;</FONT></PRE><!-- InstanceEndEditable =
--></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dc name=3Dques2> </TD>
<TD> <EM>c.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q2c" --><PRE><FONT =
color=3D#003399>retain code;</FONT></PRE><!-- InstanceEndEditable =
--></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dd name=3Dques2> </TD>
<TD> <EM>d.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q2d" -->none of the =
above<!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q3text" -->Which SAS =
statement=20
checks for the condition that <CODE>Record</CODE> equals =
<EM>C</EM> and=20
executes a single statement to read the values for =
<CODE>Amount</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" --><PRE><FONT =
color=3D#003399>if record=3Dc then input @3 Amount comma7.;</FONT> =
</PRE><!-- 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" --><PRE><FONT =
color=3D#003399>if record=3D'C' then input @3 Amount =
comma7.</FONT>;</PRE><!-- 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" --><PRE><FONT =
color=3D#003399>if record=3D'C' then do input @3 Amount =
comma7.</FONT>;</PRE><!-- 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" --><PRE><FONT =
color=3D#003399>if record=3DC then do input @3 Amount =
comma7.;</FONT></PRE><!-- InstanceEndEditable =
--></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q4text" -->After the =
value for=20
<CODE>code</CODE> is read in the sixth iteration, which =
illustration of=20
the program data vector is correct?<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>H Lettuce</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>P Green Leaf Quality Growers</FONT></T=
D></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>P Iceberg Pleasant Farm</=
FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>P Romaine Quality Growers=
</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>H Squash</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>P Yellow Tasty Acre=
s</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>P Zucchini Pleasant Farm</FONT>=
</TD></TR></TBODY></TABLE><BR><PRE><FONT color=3D#003399>data =
perm.produce (drop=3Dcode);=20
infile orders;
retain Vegetable;
input code $1. @;
if code=3D'H' then input @3 vegetable $6.;
if code=3D'P';
input @3 Variety : $10. @15 Supplier : $15.;
run;
proc print data=3Dperm.produce;
run;</FONT>=20
</PRE><!-- 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" --><IMG =
height=3D58=20
alt=3D"Program Data Vector containing 5 fields: _n_ =
contains 6, Vegetable is empty, code contains 'P', Variety is empty, =
Supplier is empty."=20
=
src=3D"http://www.sas.com/apps/OLTRN/59080/m27/images/m27qzg1.gif"=20
width=3D341> <!-- 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><IMG =
height=3D58 alt=3D"Program Data Vector containing 5 fields: _n_ contains =
6, Vegetable contains 'Squash', code contains 'P', Variety is empty, =
Supplier is empty." =
src=3D"http://www.sas.com/apps/OLTRN/59080/m27/images/m27qzg2.gif" =
width=3D341> </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><IMG =
height=3D58 alt=3D"Program Data Vector containing 5 fields: _n_ contains =
6, Vegetable contains 'Squash', code contains 'H', Variety is empty, =
Supplier is empty." =
src=3D"http://www.sas.com/apps/OLTRN/59080/m27/images/m27qzg3.gif" =
width=3D341></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" --><IMG =
height=3D58=20
alt=3D"Program Data Vector containing 5 fields: _n_ =
contains 6, Vegetable contains 'Squash', code contains 'H', Variety =
contains 'Yellow', Supplier is empty."=20
=
src=3D"http://www.sas.com/apps/OLTRN/59080/m27/images/m27qzg4.gif"=20
width=3D341><!-- InstanceEndEditable =
--></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q5text" -->What happens =
when the=20
fourth iteration of the DATA step is complete?<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>F Apples</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>V Gala  =
; $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>V Golden Delicious $1.99</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>V Rome  =
; $2.35</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>F Oranges</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>V Navel &nbs=
p; $2.79</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>V Temple &nb=
sp; $2.99</FONT></TD></TR></TBODY></TABLE><PRE><FONT =
color=3D#003399>data perm.orders (drop=3Dtype);=20
infile produce;=20
retain Fruit;=20
input type $1. @;=20
if type=3D'F' then input @3 fruit $7.;=20
if type=3D'V';=20
input @3 Variety : $16. @20 Price comma5.;=20
run; </FONT></PRE><!-- 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" -->All of the =
values in=20
the program data vector are written to the data set as the =
third=20
observation.<!-- 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" -->All of the =
values in=20
the program data vector are written to the data set as the =
fourth=20
observation. <!-- 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" -->The values =
for=20
<CODE>Fruit</CODE>, <CODE>Variety</CODE>, and =
<CODE>Price</CODE>=20
are written to the data set as the third observation. <!-- =
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" -->The values =
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -