📄 m12 - creating sas data sets from raw data - 47 of 48.mht
字号:
Item 20 24 character
Price 27 32 numeric=20
</PRE>
<TABLE title=3D"Raw Data File" cellSpacing=3D0 cellPadding=3D0 =
rules=3Dnone=20
bgColor=3D#cccccc border=3D1 frame=3Dbox>
<THEAD>
<TR>
<TD align=3Dmiddle bgColor=3D#f7f7de><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2><NOBR>1---+----10---+----20---+----30---+</NOBR></FONT></TD></TR=
></THEAD>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>310 oak pedestal table 329=
.99</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>311 maple pedestal table 369.99</FONT>=
</TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>312 brass floor lamp  =
; 79.99</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>313 glass table lamp  =
; 59.99</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>313 oak rocking chair &nbs=
p;153.99 </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>input StockNumber $ 1-3 Finish $ 5-9 Style $ 11-18=20
Item $ 20-24 Price 27-32;</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>input StockNumber $ 1-3 Price 27-32=20
Item $ 20-24 Finish $ 5-9 Style $ 11-18;</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>input $ StockNumber 1-3 Price 27-32=20
$ Item 20-24 $ Finish 5-9 $ Style 11-18;</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>input StockNumber $ 1-3 Price $ 27-32=20
Item $ 20-24 Finish $ 5-9 Style $ 11-18;</FONT></PRE><!-- =
InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q8text" -->Which =
statement=20
correctly re-defines the values of the variable =
<CODE>Income</CODE> as=20
100 percent higher? <!-- 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" --><PRE><FONT =
color=3D#003399>income=3Dincome*1.00;</FONT></PRE><!-- =
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" --><PRE><FONT =
color=3D#003399>income=3Dincome+(income*2.00);</FONT></PRE><!-- =
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" --><PRE><FONT =
color=3D#003399>income=3Dincome*2;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>income=3D*2;</FONT></PRE><!-- InstanceEndEditable =
--></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q9text" -->Which program =
correctly=20
reads instream data? <!-- InstanceEndEditable -->
<P>
<TABLE border=3D0>
<TBODY>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Da name=3Dques9> </TD>
<TD> <EM>a.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q9a" --><PRE><FONT =
color=3D#003399>data finance.newloan;
input datalines;
if country=3D'JAPAN';
MonthAvg=3Damount/12;
1998 US CARS 194324.12
1998 US TRUCKS 142290.30
1998 CANADA CARS 10483.44
1998 CANADA TRUCKS 93543.64
1998 MEXICO CARS 22500.57
1998 MEXICO TRUCKS 10098.88
1998 JAPAN CARS 15066.43
1998 JAPAN TRUCKS 40700.34
;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Db name=3Dques9> </TD>
<TD> <EM>b.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q9b" --><PRE><FONT =
color=3D#003399>data finance.newloan;
input Year 1-4 Country $ 6-11=20
Vehicle $ 13-18 Amount 20-28;
if country=3D'JAPAN';
MonthAvg=3Damount/12;
datalines;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dc name=3Dques9> </TD>
<TD> <EM>c.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q9c" --><PRE><FONT =
color=3D#003399>data finance.newloan;
input Year 1-4 Country 6-11=20
Vehicle 13-18 Amount 20-28;
if country=3D'JAPAN';
MonthAvg=3Damount/12;
datalines;
1998 US CARS 194324.12
1998 US TRUCKS 142290.30
1998 CANADA CARS 10483.44
1998 CANADA TRUCKS 93543.64
1998 MEXICO CARS 22500.57
1998 MEXICO TRUCKS 10098.88
1998 JAPAN CARS 15066.43
1998 JAPAN TRUCKS 40700.34
;</FONT></PRE><!-- InstanceEndEditable --></TD></TR>
<TR vAlign=3Dtop>
<TD><INPUT type=3Dradio value=3Dd name=3Dques9> </TD>
<TD> <EM>d.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q9d" --><PRE><FONT =
color=3D#003399>data finance.newloan;
input Year 1-4 Country $ 6-11=20
Vehicle $ 13-18 Amount 20-28;
if country=3D'JAPAN';
MonthAvg=3Damount/12;
datalines;
1998 US CARS 194324.12
1998 US TRUCKS 142290.30
1998 CANADA CARS 10483.44
1998 CANADA TRUCKS 93543.64
1998 MEXICO CARS 22500.57
1998 MEXICO TRUCKS 10098.88
1998 JAPAN CARS 15066.43
1998 JAPAN TRUCKS 40700.34
;</FONT></PRE><!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q10text" -->Which SAS =
statement=20
subsets the raw data shown below so that only the observations =
in which=20
<CODE>Sex</CODE> (in the second field) has a value of <EM>F</EM> =
are=20
processed?<BR><BR>
<TABLE title=3D"Raw Data File" cellSpacing=3D0 cellPadding=3D0 =
rules=3Dnone=20
bgColor=3D#cccccc border=3D1 frame=3Dbox>
<THEAD>
<TR>
<TD align=3Dmiddle bgColor=3D#f7f7de><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2><NOBR>----+----10---+----20---+--</NOBR></FONT></TD></TR></THEAD=
>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>Alfred M 14 69.0 112.5</FONT></TD></TR=
>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>Becka F 13 65.3 98.0 </FONT=
></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>Gail F 14 64.3 90.0 <=
/FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>Jeffrey M 13 62.5 84.0</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>John M 12 59.0 99.5</FONT>=
</TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>Karen F 12 56.3 77.0 </FONT=
></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>Mary F 15 66.5 112.0 =
</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>Philip M 16 72.0 150.0 </FONT></T=
D></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>Sandy F 11 51.3 50.5 </FONT=
></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>Tammy F 14 62.8 102.5 </FON=
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -