📄 m40 - creating enhanced list and summary reports - 39 of 40.mht
字号:
define baths / max 'Maximum/Baths';</FONT></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><FONT =
color=3D#003399>define style / order;
define bedrooms / mean 'Average/Bedrooms';
define baths / max 'Maximum/Baths';</FONT></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" --><PRE><FONT =
color=3D#003399>define style / group;
define bedrooms / 'Average/Bedrooms';
define baths / 'Maximum/Baths'</FONT></PRE><!-- InstanceEndEditable =
--></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q5text" -->Which program =
does=20
<STRONG>not</STRONG> contain an error? <!-- 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" --><PRE><FONT =
color=3D#003399>proc report data=3Dsasuser.houses nowd;
column style bedrooms baths;
define style / order;
define bedbathratio / computed format=3D4.2;
compute bedbathratio;
bedbathratio=3Dbaths.sum/bedrooms.sum;
endcomp;
run;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>proc report data=3Dsasuser.houses nowd;
column style bedrooms baths BedBathRatio;
define style / order;
define bedbathratio / order format=3D4.2;
compute bedbathratio;
bedbathratio=3Dbaths.sum/bedrooms.sum;
endcomp;
run;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>proc report data=3Dsasuser.houses nowd;
column style bedrooms baths BedBathRatio;
define style / order;
define bedbathratio / computed format=3D4.2;
compute bedbathratio;
bedbathratio=3Dbaths.sum/bedrooms.sum;
endcomp;
run;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>proc report data=3Dsasuser.houses nowd;
column style bedrooms baths BedBathRatio;
define style / order;
define bedbathratio / computed format=3D4.2;
compute bedbathratio;
bedbathratio=3Dbaths/bedrooms;
endcomp;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q6text" -->What output =
does this=20
PROC REPORT step produce? <PRE><FONT color=3D#003399>proc report =
data=3Dsasuser.houses nowd;
column style sqfeet bedrooms price;
run;</FONT></PRE><!-- 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" -->a list report =
ordered=20
by values of the first variable in the COLUMN =
statement<!-- 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" -->a summary =
report=20
ordered by values of the first variable in the COLUMN =
statement<!-- 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" -->a list report =
that=20
displays a row for each observation in the input data set =
and=20
which calculates the SUM statistic for numeric =
variables<!-- 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" -->a list report =
that=20
calculates the N (frequency) statistic for character =
variables<!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q7text" -->Which of the =
following=20
programs produces this output?<BR><BR>
<TABLE title=3D"PROC REPORT output" borderColor=3D#000000 =
cellSpacing=3D1=20
cellPadding=3D2 rules=3Dgroups bgColor=3D#fffff0 border=3D1 =
frame=3Dbox>
<THEAD>
<TR>
<TD align=3Dmiddle bgColor=3D#cccccc colSpan=3D4><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#0033aa=20
size=3D3><B>Style</B></FONT></TD>
<TD align=3Dmiddle bgColor=3D#cccccc><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#0033aa=20
size=3D3><B> </B></FONT></TD></TR>
<TR>
<TD align=3Dmiddle bgColor=3D#cccccc><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#0033aa=20
size=3D3><B>CONDO</B></FONT></TD>
<TD align=3Dmiddle bgColor=3D#cccccc><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#0033aa=20
size=3D3><B>RANCH</B></FONT></TD>
<TD align=3Dmiddle bgColor=3D#cccccc><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#0033aa=20
size=3D3><B>SPLIT</B></FONT></TD>
<TD align=3Dmiddle bgColor=3D#cccccc><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#0033aa=20
size=3D3><B>TWOSTORY</B></FONT></TD>
<TD align=3Dmiddle bgColor=3D#cccccc><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#0033aa =
size=3D3><B>Average=20
Price</B></FONT></TD></TR></THEAD>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>4</FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>4</FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>3</FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>4</FONT></TD>
<TD align=3Dright bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000=20
size=3D2>$82,720</FONT></TD></TR></TBODY></TABLE><!-- =
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" --><PRE><FONT =
color=3D#003399>proc report data=3Dsasuser.houses nowd;
column style condo range split
twostory price;
define price / mean 'Average Price';
run;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>proc report data=3Dsasuser.houses nowd;
column style price;
define style / group;
define price / mean 'Average Price';
run;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>proc report data=3Dsasuser.houses nowd;
column style price;
define style / across;
define price / mean 'Average Price';
run;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>proc report data=3Dsasuser.houses nowd;
column style price;
define style / across 'CONDO' 'RANCH'
'SPLIT' 'TWOSTORY';
define price / mean 'Average Price';
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q8text" -->If you submit =
this=20
program, where does your PROC REPORT output appear? <PRE><FONT =
color=3D#003399>proc report data=3Dsasuser.houses nowd;
column style sqfeet bedrooms price;
define style / group;
run;</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" -->in the PROC =
REPORT=20
window<!-- 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" -->as HTML =
and/or SAS=20
listing output<!-- 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" -->both of the =
above<!-- 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" -->neither of =
the above<!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q9text" -->How can you =
create=20
output with headings that break as shown below?<BR><BR>
<TABLE title=3D"PROC REPORT Output, SAS Listing" cellSpacing=3D0 =
cellPadding=3D10 bgColor=3D#f7f7de border=3D1>
<TBODY>
<TR>
<TD>
<TABLE cellSpacing=3D0 cellPadding=3D0 bgColor=3D#f7f7de =
border=3D0=20
frame=3Dbox>
<THEAD>
<TR bgColor=3D#f7f7de>
<TD align=3Dleft>
<DIV align=3Dcenter><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000 size=3D2>Style of<BR>House =
</FONT></DIV></TD>
<TD align=3Dleft>
<DIV align=3Dright><FONT face=3D"Courier New, =
Courier"=20
color=3D#000000=20
=
size=3D2> Average⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -