📄 m23 - reading free-format data - 39 of 40.mht
字号:
<TD><INPUT type=3Dradio value=3Dd name=3Dques2> </TD>
<TD> <EM>d.</EM> </TD>
<TD><!-- InstanceBeginEditable name=3D"q2d" -->mixed <!-- =
InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q3text" -->Which SAS =
program was=20
used to create the raw data file <STRONG>Teamdat</STRONG> from =
the SAS=20
data set <STRONG>Work.Scores</STRONG>?=20
<P>SAS Data Set Work.Scores=20
<TABLE title=3D"SAS Data Set" cellSpacing=3D0 cellPadding=3D3 =
bgColor=3D#f7f7de=20
border=3D1 frame=3Dbox>
<THEAD>
<TR>
<TD align=3Dmiddle bgColor=3D#f7f7de><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2><B>Obs</B></FONT></TD>
<TD align=3Dleft bgColor=3D#f7f7de><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2><B>Name</B></FONT></TD>
<TD align=3Dmiddle bgColor=3D#f7f7de><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2><B>HighScore</B></FONT></TD>
<TD align=3Dmiddle bgColor=3D#f7f7de><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2><B>Team</B></FONT></TD></TR></THEAD>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff>
<DIV align=3Dcenter><FONT face=3D"Verdana, Arial, =
Helvetica"=20
color=3D#000000 size=3D2>1</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>Joe</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000 =
size=3D2>87</FONT></TD>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000 =
size=3D2>Blue=20
Beetles, Durham</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff>
<DIV align=3Dcenter><FONT face=3D"Verdana, Arial, =
Helvetica"=20
color=3D#000000 size=3D2>2</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>Dani</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000 =
size=3D2>79</FONT></TD>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000 =
size=3D2>Raleigh=20
Racers, Raleigh</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff>
<DIV align=3Dcenter><FONT face=3D"Verdana, Arial, =
Helvetica"=20
color=3D#000000 size=3D2>3</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>Lisa</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000 =
size=3D2>85</FONT></TD>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000 =
size=3D2>Sand Sharks,=20
Cary</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff>
<DIV align=3Dcenter><FONT face=3D"Verdana, Arial, =
Helvetica"=20
color=3D#000000 size=3D2>4</FONT></DIV></TD>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000=20
size=3D2>Matthew</FONT></TD>
<TD align=3Dright bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000 =
size=3D2>76</FONT></TD>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Verdana, Arial, Helvetica" color=3D#000000 =
size=3D2>Blue=20
Beetles, Durham</FONT></TD></TR></TBODY></TABLE>
<P>Raw Data File Teamdat=20
<TABLE title=3D"Raw Data File" cellSpacing=3D0 cellPadding=3D0 =
rules=3Dnone=20
bgColor=3D#f7f7de border=3D1 frame=3Dbox>
<THEAD>
<TR>
<TD align=3Dleft bgColor=3D#f7f7de><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>1---+----10---+----20---+----30---+</FONT></TD></TR></THEAD>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>Joe,87,"Blue Beetles, =
Durham"</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>Dani,79,"Raleigh Racers,=20
Raleigh"</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>Lisa,85,"Sand Sharks, =
Cary"</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>Matthew,76,"Blue Beetles,=20
Durham"</FONT></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" --><PRE><FONT =
color=3D#003399>data _null_;
set work.scores;
file 'c:\data\teamdat' dlm=3D',';
put name highscore team;
run;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>data _null_;
set work.scores;
file 'c:\data\teamdat' dlm=3D' ';
put name highscore team;
run;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>data _null_;
set work.scores;
file 'c:\data\teamdat' dsd;
put name highscore team;
run;</FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>data _null_;
set work.scores;
file 'c:\data\teamdat';
put name highscore team;
run;</FONT></PRE><!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q4text" -->Which SAS =
statement=20
reads the raw data values in order and assigns them to the =
variables=20
shown below?<BR><BR>Variables: <CODE>FirstName</CODE> =
(character),=20
<CODE>LastName</CODE> (character), <CODE>Age</CODE> (numeric),=20
<CODE>School</CODE> (character), <CODE>Class</CODE> (numeric)=20
<P>Raw Data File Students=20
<TABLE title=3D"Raw Data File" cellSpacing=3D0 cellPadding=3D0 =
rules=3Dnone=20
bgColor=3D#f7f7de border=3D1 frame=3Dbox>
<TBODY>
<TR>
<TD align=3Dmiddle bgColor=3D#f7f7de><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2><NOBR>1---+----10---+----20---+</NOBR></FONT></TD></TR>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>FRED JOHNSON 18 USC =
1</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>ASHLEY FERRIS 20 NCSU =
3</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 size=3D2>BETH ROSEMONT 21 UNC=20
4</FONT></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" --><PRE><FONT =
color=3D#003399>input FirstName $ LastName $ Age School $ Class;</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>input FirstName LastName Age School Class;</FONT>=20
</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>input FirstName $ 1-4 LastName $ 6-12 Age 14-15=20
School $ 17-19 Class 21;</FONT>=20
</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>input FirstName 1-4 LastName 6-12 Age 14-15=20
School 17-19 Class 21;</FONT> </PRE><!-- =
InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q5text" -->Which SAS =
statement=20
should be used to read the raw data file that is referenced by =
the=20
fileref <B>Salesrep</B>?=20
<P>Raw Data File Salesrep=20
<TABLE title=3D"Raw Data File" cellSpacing=3D0 cellPadding=3D0 =
rules=3Dnone=20
bgColor=3D#f7f7de border=3D1 frame=3Dbox>
<TBODY>
<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>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>ELAINE:FRIEDMAN:WILMINGTON:2102</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000 =
size=3D2>JIM:LLOYD:20:RALEIGH:38392</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>JENNIFER:WU:21:GREENSBORO:1436</FONT></TD></TR></TBODY></TABLE><=
!-- 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>infile salesrep;</FONT> </PRE><!-- InstanceEndEditable =
--></TD></TR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -