📄 m12 - creating sas data sets from raw data - 47 of 48.mht
字号:
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2>Rogan NY RECRTN </FONT></TD></TR></TBODY></=
TABLE> =20
<!-- 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" -->
<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---+----20---+----30</NOBR></FONT></TD></TR></T=
HEAD>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2>2803 Deborah Campos 173.97</FONT></TD></TR>=
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2>2912 Bill Marin 205=
.14</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2>3015 Helen Stinson 194.08</FONT></TD>=
</TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2>3122 Nicole Terry 187.65 <=
/FONT></TD></TR></TBODY></TABLE> =20
<!-- 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" -->
<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---+----20---+</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>Avery John $601.23=
</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2>Davison Sherrill $723.15</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2>Holbrook Grace $489.76</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT=20
face=3D"Courier New, Courier" color=3D#000000=20
=
size=3D2>Jansen Mike $638.42</FON=
T></TD></TR></TBODY></TABLE> =20
<!-- 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" -->all of the =
above<!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q6text" -->Which program =
creates=20
the output shown below?=20
<P>
<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></T=
HEAD>
<TBODY>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>3427 Chen Steve Raleigh &n=
bsp; </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>1436 Davis Lee Atlanta&nb=
sp;</FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>2812 King Vicky Memphis &n=
bsp; </FONT></TD></TR>
<TR>
<TD align=3Dleft bgColor=3D#ffffff><FONT face=3D"Courier =
New, Courier"=20
color=3D#000000=20
=
size=3D2>1653 Sanchez Jack Atlanta =
</FONT></TD></TR></TBODY></TABLE>
<P>
<TABLE title=3D"PROC PRINT 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><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#0033aa=20
size=3D3><B>Obs</B></FONT></TD>
<TD align=3Dmiddle bgColor=3D#cccccc><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#0033aa=20
size=3D3><B>ID</B></FONT></TD>
<TD align=3Dleft bgColor=3D#cccccc><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#0033aa size=3D3><B>LastName</B></FONT></TD>
<TD align=3Dmiddle bgColor=3D#cccccc><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#0033aa=20
size=3D3><B>FirstName</B></FONT></TD>
<TD align=3Dleft bgColor=3D#cccccc><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#0033aa=20
=
size=3D3><B> City</B></FONT></TD></TR></THEAD>
<TBODY>
<TR>
<TD align=3Dright bgColor=3D#cccccc><B><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#003399 =
size=3D3>1</FONT></B></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>3427</FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>Chen </FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>Steve</FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>Raleigh </FONT></TD></TR>
<TR>
<TD align=3Dright bgColor=3D#cccccc><B><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#003399 =
size=3D3>2</FONT></B></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>1436</FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>Davis </FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>Lee </FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>Atlanta</FONT></TD></TR>
<TR>
<TD align=3Dright bgColor=3D#cccccc><B><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#003399 =
size=3D3>3</FONT></B></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>2812</FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>King </FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>Vicky</FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>Memphis </FONT></TD></TR>
<TR>
<TD align=3Dright bgColor=3D#cccccc><B><FONT=20
face=3D"Arial, Helvetica, Helv" color=3D#003399 =
size=3D3>4</FONT></B></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>1653</FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>Sanchez</FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>Jack </FONT></TD>
<TD align=3Dleft bgColor=3D#efefef><FONT face=3D"Arial, =
Helvetica, Helv"=20
color=3D#000000 size=3D2>Atlanta =
</FONT></TD></TR></TBODY></TABLE><BR><!-- 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" --><PRE><FONT =
color=3D#003399>data work.salesrep;
infile empdata;=20
input ID $ 1-4 LastName $ 6-12=20
FirstName $ 14-18 City $ 20-29;=20
run;=20
proc print data=3Dwork.salesrep;=20
run; </FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>data work.salesrep;
infile empdata;=20
input ID $ 1-4 Name $ 6-12=20
FirstName $ 14-18 City $ 20-29;=20
run;=20
proc print data=3Dwork.salesrep;=20
run; </FONT></PRE><!-- 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" --><PRE><FONT =
color=3D#003399>data work.salesrep;
infile empdata;=20
input ID $ 1-4 name1 $ 6-12=20
name2 $ 14-18 City $ 20-29;=20
run;=20
proc print data=3Dwork.salesrep;=20
run; </FONT></PRE><!-- 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" -->all of the =
above<!-- InstanceEndEditable --></TD></TR></TBODY></TABLE>
<P></P>
<LI><!-- InstanceBeginEditable name=3D"q7text" -->Which =
statement=20
correctly reads the fields in the following order:=20
<CODE>StockNumber</CODE>, <CODE>Price</CODE>, <CODE>Item</CODE>, =
<CODE>Finish</CODE>, <CODE>Style</CODE>? <PRE><STRONG>Field Name =
Start Column End Column Data Type </STRONG>
StockNumber 1 3 character=20
Finish 5 9 character
Style 11 18 character
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -