📄 m40 - creating enhanced list and summary reports - 39 of 40.mht
字号:
<TR bgColor=3D#f7f7de>
<TD align=3Dleft> </TD>
<TD align=3Dleft bgColor=3D#f7f7de> </TD>
<TD align=3Dleft> </TD></TR></THEAD>
<TBODY>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>RANCH</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>720</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$34,550</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>TWOSTORY</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1040</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$55,850</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>SPLIT</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1190</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$65,850</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>TWOSTORY</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1240</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$69,250</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>RANCH</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1250</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$64,000</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>SPLIT</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1305</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$73,650</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>CONDO</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1390</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$79,350</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>CONDO</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1400</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$80,050</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>RANCH</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1500</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$86,650</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>RANCH</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1535</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$89,100</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>SPLIT</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1615</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$94,450</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>TWOSTORY</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1745</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$102,950</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>TWOSTORY</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1810</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$107,250</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>CONDO</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>1860</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 =
size=3D2>$110,700</FONT></DIV></TD></TR>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>CONDO</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#f7f7de>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>2105</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000=20
=
size=3D2>$127,150</FONT></DIV></TD></TR></TBODY></TABLE></TD></TR></TBODY=
></TABLE><!-- InstanceEndEditable -->
<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" -->SKIPLINE and =
FORMAT=3D<!-- 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" -->CENTER, =
HEADLINE,=20
HEADSKIP, and either WIDTH=3D, SPACING=3D, or =
FORMAT=3D<!-- 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" -->SPACING=3D =
only<!-- 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" -->CENTER, =
FORMAT=3D, and=20
HEADLINE<!-- InstanceEndEditable =
--></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q4text" -->To create a =
summary=20
report that shows the average number of bedrooms and the maximum =
number=20
of baths for each style of house, which DEFINE statements do you =
use in=20
your PROC REPORT step? <!-- 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" --><PRE><FONT =
color=3D#003399>define style / center 'Style of/House';
define bedrooms / mean 'Average/Bedrooms';
define baths / max 'Maximum/Baths';</FONT></PRE><!-- 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><FONT =
color=3D#003399>define style / group;
define bedrooms / mean 'Average/Bedrooms';
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -