📄 m39 - creating and managing variables - 35 of 36.mht
字号:
face=3D"Arial, Helvetica, Helv" color=3D#000000 =
size=3D2>maple</FONT></TD>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000=20
size=3D2>pedestal</FONT></TD>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000 =
size=3D2>table</FONT></TD>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000=20
=
size=3D2> 699.98</FO=
NT></TD></TR>
<TR>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000 =
size=3D2>312</FONT></TD>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000 =
size=3D2>brass</FONT></TD>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000=20
size=3D2><NOBR>floor</NOBR></FONT></TD>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000 =
size=3D2>lamp</FONT></TD>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000=20
=
size=3D2> 779.97</FO=
NT></TD></TR>
<TR>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000 =
size=3D2>313</FONT></TD>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000 =
size=3D2>glass</FONT></TD>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000 =
size=3D2>table</FONT></TD>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000 =
size=3D2>lamp</FONT></TD>
<TD borderColor=3D#000000 align=3Dleft =
bgColor=3D#efefef><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#000000=20
=
size=3D2> 839.96</FO=
NT></TD></TR></TBODY></TABLE><BR><!-- InstanceEndEditable -->
<P>
<TABLE border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Da name=3Dques1> </TD>
<TD> <EM>a.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q1a" --><PRE><FONT =
color=3D#003399>data test2;
infile furnture;=20
input StockNum $ 1-3 Finish $ 5-9 Style $ 11-18
Item $ 20-24 Price 26-31;
if finish=3D'oak' then delete;
retain TotPrice 100;<BR> totalprice+price;
drop price;<BR>run;
proc print data=3Dtest2 noobs;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Db name=3Dques1> </TD>
<TD> <EM>b.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q1b" --><PRE><FONT =
color=3D#003399>data test2;
infile furnture;=20
input StockNum $ 1-3 Finish $ 5-9 Style $ 11-18
Item $ 20-24 Price 26-31;
if finish=3D'oak' and price<200 then delete;
TotalPrice+price;
run;
proc print data=3Dtest2 noobs;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dc name=3Dques1> </TD>
<TD> <EM>c.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q1c" --><PRE><FONT =
color=3D#003399>data test2(drop=3Dprice);
infile furnture;=20
input StockNum $ 1-3 Finish $ 5-9 Style $ 11-18
Item $ 20-24 Price 26-31;
if finish=3D'oak' and price<200 then delete;
TotalPrice+price;
run;
proc print data=3Dtest2 noobs;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dd name=3Dques1> </TD>
<TD> <EM>d.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q1d" --><PRE><FONT =
color=3D#003399>data test2;
infile furnture;=20
input StockNum $ 1-3 Finish $ 5-9 Style $ 11-18
Item $ 20-24 Price 26-31;
if finish=3Doak and price<200 then delete price;
TotalPrice+price;
run;
proc print data=3Dtest2 noobs;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q2text" -->How is the =
variable=20
<CODE>Amount</CODE> labeled and formatted in the PROC PRINT =
output? <PRE><FONT color=3D#003399>data credit;
infile creddata;
input Account $ 1-5 Name $ 7-25 Type $ 27=20
Transact $ 29-35 Amount 37-50;=20
label amount=3D'Amount of Loan';
format amount dollar12.2;
run;
proc print data=3Dcredit label;
label amount=3D'Total Amount Loaned';
format amount comma10.;
run;</FONT></PRE><!-- InstanceEndEditable -->
<P>
<TABLE border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Da name=3Dques2> </TD>
<TD> <EM>a.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q2a" -->label<STRONG> =
Amount=20
of Loan</STRONG>, format <STRONG>DOLLAR12.2</STRONG><!-- =
InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Db name=3Dques2> </TD>
<TD> <EM>b.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q2b" -->label =
<STRONG>Total=20
Amount Loaned</STRONG>, format<STRONG> =
COMMA10.</STRONG><!-- 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" -->label<STRONG> =
Amount</STRONG>, default format <!-- 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" -->The PROC =
PRINT step=20
does not execute because two labels and two formats are =
assigned=20
to the same=20
variable.<!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q3text" -->Consider the =
IF-THEN=20
statement shown below. When the statement is executed, which =
expression=20
is evaluated first? <PRE><FONT color=3D#003399>if =
finlexam>=3D95
and (research=3D'A' or
(project=3D'A' and present=3D'A'))
then Grade=3D'A+';</FONT></PRE><!-- 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" --><TT><FONT=20
color=3D#003399>finlexam>=3D95</FONT></TT> <!-- =
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" --><TT><FONT=20
color=3D#003399>research=3D'A'</FONT></TT> <!-- =
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" --><TT><FONT=20
color=3D#003399>project=3D'A' and =
present=3D'A'</FONT></TT> <!-- 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" --><TT><FONT=20
color=3D#003399>research=3D'A' or<BR>(project=3D'A' and=20
present=3D'A')</FONT></TT>=20
<!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q4text" -->Consider the =
small raw=20
data file and program shown below. What is the value of=20
<CODE>Count</CODE> after the fourth record is read?=20
<P>
<TABLE cellSpacing=3D0 cellPadding=3D0 border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD noWrap align=3Dmiddle>
<TABLE title=3D"Raw Data File" cellSpacing=3D0 =
cellPadding=3D0=20
rules=3Dnone bgColor=3D#cccccc border=3D1 frame=3Dbox>
<THEAD>
<TR>
<TD align=3Dmiddle bgColor=3D#f7f7de><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2><NOBR>1---+----10</NOBR></FONT></TD></TR></THEAD>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
size=3D2> 10</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
size=3D2> 20</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
size=3D2> </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
size=3D2> 40</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2> 50</FONT></TD></TR></TBODY></TABLE></TD>
<TD align=3Dleft><PRE><FONT color=3D#003399>
data work.newnums;
infile numbers;
input Tens 2-3;
Count+tens;
run;</FONT></PRE></TD></TR></TBODY></TABLE><!-- 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" -->missing<!-- =
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -