m04 - creating list reports - 54 of 55.mht

sas的考试样题

            <TD>&nbsp;<EM>a.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q1a" --><PRE><FONT =
color=3D#003399>proc print data=3Dflights.laguardia noobs;
   var on changed flight;
   where on&gt;=3D160;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Db name=3Dques1> </TD>
            <TD>&nbsp;<EM>b.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q1b" --><PRE><FONT =
color=3D#003399>proc print data=3Dflights.laguardia;
   var date on changed flight;
   where changed&gt;3;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Dc name=3Dques1> </TD>
            <TD>&nbsp;<EM>c.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q1c" --><PRE><FONT =
color=3D#003399>proc print data=3Dflights.laguardia label;
   id date;
   var boarded transferred flight;
   label boarded=3D'On' transferred=3D'Changed';
   where flight=3D'219';
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Dd name=3Dques1> </TD>
            <TD>&nbsp;<EM>d.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q1d" --><PRE><FONT =
color=3D#003399>proc print flights.laguardia noobs;
    id date;
 </FONT>   <FONT color=3D#003399>var date on changed flight;
    where flight=3D'219';
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
        <P></P>
        <LI><!-- InstanceBeginEditable name=3D"q2text" -->Which of the =
following=20
        PROC PRINT steps is correct if labels are not stored with the =
data set? <!-- InstanceEndEditable -->
        <P>
        <TABLE border=3D0>
          <TBODY>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Da name=3Dques2> </TD>
            <TD>&nbsp;<EM>a.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q2a" --><PRE><FONT =
color=3D#003399>proc print data=3Dallsales.totals label;
   label region8=3D'Region 8 Yearly Totals';
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Db name=3Dques2> </TD>
            <TD>&nbsp;<EM>b.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q2b" --><PRE><FONT =
color=3D#003399>proc print data=3Dallsales.totals;
   label region8=3D'Region 8 Yearly Totals';
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Dc name=3Dques2> </TD>
            <TD>&nbsp;<EM>c.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q2c" --><PRE><FONT =
color=3D#003399>proc print data allsales.totals label noobs;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Dd name=3Dques2> </TD>
            <TD>&nbsp;<EM>d.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q2d" --><PRE><FONT =
color=3D#003399>proc print allsales.totals label;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
        <P></P>
        <LI><!-- InstanceBeginEditable name=3D"q3text" -->Which of the =
following=20
        statements selects from a data set only those observations for =
which the=20
        value of the variable <CODE>Style</CODE> is <EM>RANCH</EM>,=20
        <EM>SPLIT</EM>, or <EM>TWOSTORY</EM>? <!-- InstanceEndEditable =
-->
        <P>
        <TABLE border=3D0>
          <TBODY>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Da name=3Dques3> </TD>
            <TD>&nbsp;<EM>a.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q3a" --><PRE><FONT =
color=3D#003399>where style=3D'RANCH' or 'SPLIT' or 'TWOSTORY';</FONT> =
</PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Db name=3Dques3> </TD>
            <TD>&nbsp;<EM>b.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q3b" --><PRE><FONT =
color=3D#003399>where style in 'RANCH' or 'SPLIT' or 'TWOSTORY';</FONT> =
</PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Dc name=3Dques3> </TD>
            <TD>&nbsp;<EM>c.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q3c" --><PRE><FONT =
color=3D#003399>where style in (RANCH, SPLIT, TWOSTORY);</FONT> =
</PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Dd name=3Dques3> </TD>
            <TD>&nbsp;<EM>d.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q3d" --><PRE><FONT =
color=3D#003399>where style in ('RANCH','SPLIT','TWOSTORY');</FONT> =
</PRE><!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
        <P></P>
        <LI><!-- InstanceBeginEditable name=3D"q4text" -->If you want to =
sort your=20
        data and create a temporary data set named <STRONG>Calc</STRONG> =
to=20
        store the sorted data, which of the following steps should you =
submit? <!-- InstanceEndEditable -->
        <P>
        <TABLE border=3D0>
          <TBODY>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Da name=3Dques4> </TD>
            <TD>&nbsp;<EM>a.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q4a" --><PRE><FONT =
color=3D#003399>proc sort data=3Dwork.calc out=3Dfinance.dividend;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Db name=3Dques4> </TD>
            <TD>&nbsp;<EM>b.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q4b" --><PRE><FONT =
color=3D#003399>proc sort dividend out=3Dcalc;
   by account;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Dc name=3Dques4> </TD>
            <TD>&nbsp;<EM>c.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q4c" --><PRE><FONT =
color=3D#003399>proc sort data=3Dfinance.dividend out=3Dwork.calc;
   by account;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
          <TR vAlign=3Dtop>
            <TD><INPUT type=3Dradio value=3Dd name=3Dques4> </TD>
            <TD>&nbsp;<EM>d.</EM>&nbsp;&nbsp;</TD>
            <TD><!-- InstanceBeginEditable name=3D"q4d" --><PRE><FONT =
color=3D#003399>proc sort from finance.dividend to calc;
   by account;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
        <P></P>
        <LI><!-- InstanceBeginEditable name=3D"q5text" -->Which options =
are used=20
        to create the following PROC PRINT output? <BR><BR>
        <TABLE title=3D"PROC PRINT listing output" cellSpacing=3D0 =
cellPadding=3D10=20
        bgColor=3D#f7f7de border=3D1>
          <TBODY>
          <TR>
            <TD>
              <P align=3Dright><FONT face=3D"Courier New, Courier, mono" =

              color=3D#000000>13:27 Monday, March 22, 1999</FONT></P>
              <TABLE cellSpacing=3D0 cellPadding=3D0 bgColor=3D#f7f7de =
border=3D0=20
              frame=3Dbox>
                <THEAD>
                <TR bgColor=3D#f7f7de>
                  <TD align=3Dmiddle><FONT face=3D"Courier New, Courier" =

                    color=3D#000000=20
                  size=3D2>&nbsp;&nbsp;Patient&nbsp;&nbsp;</FONT></TD>
                  <TD align=3Dmiddle><FONT face=3D"Courier New, Courier" =

                    color=3D#000000=20
                  size=3D2>&nbsp;&nbsp;Arterial&nbsp;&nbsp;</FONT></TD>
                  <TD align=3Dmiddle><FONT face=3D"Courier New, Courier" =

                    color=3D#000000 =
size=3D2>&nbsp;&nbsp;Heart&nbsp;&nbsp;</FONT></TD>
                  <TD align=3Dmiddle><FONT face=3D"Courier New, Courier" =

                    color=3D#000000=20
                  size=3D2>&nbsp;&nbsp;Cardiac&nbsp;&nbsp;</FONT></TD>
                  <TD align=3Dmiddle><FONT face=3D"Courier New, Courier" =

                    color=3D#000000=20
                  =
size=3D2>&nbsp;&nbsp;Urinary&nbsp;&nbsp;</FONT></TD></TR>
                <TR bgColor=3D#f7f7de>
                  <TD align=3Dleft bgColor=3D#f7f7de>&nbsp;=20
                    <DIV align=3Dcenter></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter></DIV></TD>
                  <TD align=3Dleft>&nbsp;</TD>
                  <TD align=3Dleft>&nbsp;</TD>
                  <TD align=3Dleft>&nbsp;</TD></TR></THEAD>
                <TBODY>
                <TR bgColor=3D#f7f7de>
                  <TD align=3Dleft bgColor=3D#f7f7de>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>203</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>88</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>95</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>66</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>110</FONT></DIV></TD></TR>
                <TR bgColor=3D#f7f7de>
                  <TD align=3Dleft bgColor=3D#f7f7de>&nbsp;=20
                    <DIV align=3Dcenter></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter></DIV></TD></TR>
                <TR bgColor=3D#f7f7de>
                  <TD align=3Dleft bgColor=3D#f7f7de>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>&nbsp;54</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>83</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>183</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>95</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 =
size=3D2>&nbsp;&nbsp;0</FONT></DIV></TD></TR>
                <TR bgColor=3D#f7f7de>
                  <TD align=3Dleft bgColor=3D#f7f7de>&nbsp;=20
                    <DIV align=3Dcenter></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter></DIV></TD></TR>
                <TR bgColor=3D#f7f7de>
                  <TD align=3Dleft bgColor=3D#f7f7de>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>664</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>72</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>111</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
                    color=3D#000000 size=3D2>332</FONT></DIV></TD>
                  <TD align=3Dleft>
                    <DIV align=3Dcenter><FONT face=3D"Courier New, =