📄 m20 - combining sas data sets - 47 of 49.mht
字号:
<DT><FONT color=3D#003399><STRONG>RUN;</STRONG></FONT> =
</DT></DL>
<P><STRONG>Interleaving</STRONG> </P>
<DL>
<DT><FONT color=3D#003399><STRONG>PROC SORT=20
DATA=3D</STRONG><EM>SAS-data-set</EM>=20
=
<STRONG>OUT=3D</STRONG><EM>SAS-data-set</EM><STRONG>;</STRONG></FONT>=20
<DD><FONT color=3D#003399><STRONG>BY</STRONG>=20
<EM>variable(s)</EM><STRONG>;</STRONG></FONT>=20
<DT><FONT color=3D#003399><STRONG>RUN;</STRONG></FONT>=20
<DT><FONT color=3D#003399><STRONG>DATA</STRONG>=20
<EM>output-SAS-data-set</EM><STRONG>;</STRONG></FONT>=20
<DD><FONT color=3D#003399><A=20
onmouseover=3D"window.status=3D'Display details on =
interleaving.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D'';"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m20/m20_11.htm"><STRONG>SET</=
STRONG>=20
<EM>SAS-data-set-1 =
SAS-data-set-2</EM><STRONG>;</STRONG></A></FONT>=20
<DD><FONT color=3D#003399><A=20
onmouseover=3D"window.status=3D'Display details on =
interleaving.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D'';"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m20/m20_11.htm"><STRONG>BY</S=
TRONG>=20
<EM>variable(s)</EM><STRONG>;</STRONG></A></FONT>=20
<DT><FONT color=3D#003399><STRONG>RUN;</STRONG></FONT> =
</DT></DL>
<P><STRONG>Match-Merging</STRONG> </P>
<DL>
<DT><FONT color=3D#003399><STRONG>PROC SORT=20
DATA=3D</STRONG><EM>SAS-data-set</EM>=20
=
<STRONG>OUT=3D</STRONG><EM>SAS-data-set</EM><STRONG>;</STRONG></FONT>=20
<DD><FONT color=3D#003399><STRONG>BY</STRONG>=20
<EM>variable(s)</EM><STRONG>;</STRONG></FONT>=20
<DT><FONT color=3D#003399><STRONG>RUN;</STRONG></FONT>=20
<DT><NOBR><FONT color=3D#003399><STRONG>DATA</STRONG>=20
<EM>output-SAS-data-set</EM> <A=20
onmouseover=3D"window.status=3D'Display details on the DROP=3D =
and KEEP=3D options.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D'';"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m20/m20_42.htm"><STRONG>(DROP=
=3D</STRONG><EM>variable(s)</EM>=20
|=20
=
<STRONG>KEEP=3D</STRONG><EM>variable(s)</EM><STRONG>);</STRONG></A></FONT=
></NOBR>=20
<DD><FONT color=3D#003399><A=20
onmouseover=3D"window.status=3D'Display details on =
match-merging.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D'';"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m20/m20_14.htm"><STRONG>MERGE=
</STRONG>=20
<EM>SAS-data-set-1 SAS-data-set-2</EM></A></FONT>=20
<DD><NOBR> <FONT =
color=3D#003399><A=20
onmouseover=3D"window.status=3D'Display details on the =
RENAME=3D option.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m20/m20_33.htm"><STRONG>(RENA=
ME=3D</STRONG><STRONG>(</STRONG><EM>old-variable-name</EM>=3D<EM>new-vari=
able-name</EM><STRONG>)</STRONG></A></FONT></NOBR>=20
<DD> <FONT =
color=3D#003399><A=20
onmouseover=3D"window.status=3D'Display details on the IN=3D =
option.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D'';"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m20/m20_37.htm"><STRONG>IN=3D=
</STRONG><EM>variable</EM></A>=20
<A=20
onmouseover=3D"window.status=3D'Display details on the DROP=3D =
and KEEP=3D options.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D'';"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m20/m20_42.htm"><STRONG>DROP=3D=
</STRONG><EM>variable(s)</EM>=20
|=20
=
<STRONG>KEEP=3D</STRONG><EM>variable(s)</EM><STRONG>);</STRONG></A></FONT=
>=20
<DD><FONT color=3D#003399><A=20
onmouseover=3D"window.status=3D'Display details on the BY =
statement.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m20/m20_14.htm"><STRONG>BY</S=
TRONG>=20
<EM>variable(s)</EM><STRONG>;</STRONG></A></FONT>=20
<DD><A=20
onmouseover=3D"window.status=3D'Display details on the =
subsetting IF statement.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m20/m20_39.htm"><STRONG>IF</S=
TRONG>=20
<EM>expression</EM><STRONG>;</STRONG></A>=20
<DT><FONT color=3D#003399><STRONG>RUN;</STRONG></FONT>=20
</DT></DL></BLOCKQUOTE></TD></TR></TBODY></TABLE></CENTER>
<CENTER>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD align=3Dleft>
<HR>
</TD></TR></TBODY></TABLE><BR></CENTER></CENTER><!-- =
InstanceEndEditable -->
<P><!-- InstanceBeginEditable name=3D"sampleprogram" -->
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD align=3Dleft><STRONG><A name=3DSample>Sample =
Programs</A></STRONG>=20
<BLOCKQUOTE>
<P><STRONG>One-to-One Reading</STRONG> </P></BLOCKQUOTE><PRE> =
<FONT color=3D#003399>data clinic.one2one;</FONT>
<FONT color=3D#003399>set clinic.patients;</FONT>
<FONT color=3D#003399>if age<60;</FONT>
<FONT color=3D#003399>set clinic.measure;</FONT>
<FONT color=3D#003399>run;</FONT></PRE>
<BLOCKQUOTE>
<P><STRONG>Concatenating</STRONG> </P></BLOCKQUOTE><PRE> =
<FONT color=3D#003399>data clinic.concat;</FONT>
<FONT color=3D#003399>set clinic.therapy1999 =
clinic.therapy2000;</FONT>
<FONT color=3D#003399>run;</FONT></PRE>
<BLOCKQUOTE>
<P><STRONG>Interleaving</STRONG> </P></BLOCKQUOTE><PRE> =
<FONT color=3D#003399>data clinic.intrleav;</FONT>
<FONT color=3D#003399>set clinic.therapy1999 =
clinic.therapy2000;</FONT>
<FONT color=3D#003399>by month;</FONT>
<FONT color=3D#003399>run;</FONT></PRE>
<BLOCKQUOTE>
<P><STRONG>Match-Merging</STRONG> </P></BLOCKQUOTE><PRE> =
<FONT color=3D#003399>data clinic.merged(drop=3Did);</FONT>
<FONT color=3D#003399>merge clinic.demog(in=3Dindemog</FONT>
<FONT =
color=3D#003399>rename=3D(date=3DBirthDate))</FONT>
<FONT color=3D#003399>clinic.visit(drop=3Dweight =
in=3Dinvisit</FONT>
<FONT =
color=3D#003399>rename=3D(date=3DVisitDate));</FONT>
<FONT color=3D#003399>by id;</FONT>
<FONT color=3D#003399>if indemog and invisit;</FONT>
<FONT color=3D#003399>run;</FONT></PRE>
<P>
<HR>
</TD></TR></TBODY></TABLE><BR><!-- InstanceEndEditable -->
<P><!-- InstanceBeginEditable name=3D"pointstoremember" -->
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD align=3Dleft><STRONG><A name=3DPoints>Points to =
Remember</A></STRONG>=20
<UL>
<LI>You can rename any number of variables in each occurrence of =
the=20
RENAME=3D option.<BR><BR>
<LI>In match-merging, the IN=3D data set option can apply to any =
data set=20
in the MERGE statement. The RENAME=3D, DROP=3D, and KEEP=3D =
options can apply=20
to any data set in the DATA or MERGE statements. <BR><BR>
<LI>Use the KEEP=3D option instead of the DROP=3D option if more =
variables=20
are dropped than kept.<BR><BR>
<LI>When you specify multiple data set options for a particular =
data=20
set, enclose them in a single set of parentheses.=20
</LI></UL></TD></TR></TBODY></TABLE><!-- InstanceEndEditable =
--></CENTER><!-- #BeginLibraryItem "/Library/nav_regular_bottom.lbi" -->
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%">
<TBODY>
<TR>
<TD width=3D14><IMG height=3D7 alt=3D""=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/linebox.gif"=
=20
width=3D14></TD>
<TD colSpan=3D2><IMG height=3D7 alt=3D""=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/linegray.gif=
"=20
width=3D"100%"></TD></TR>
<TR>
<TD> </TD>
<TD vAlign=3Dtop><FONT face=3D"Verdana, Arial, Helvetica, Sans =
Serif"=20
color=3Dgray size=3D1><A class=3Dcopyrightlink=20
href=3D"javascript:%20openOther('../copyrite.htm')"><FONT=20
face=3D"Arial, Helvetica, sans-serif">Copyright</FONT></A> <FONT=20
face=3D"Arial, Helvetica, sans-serif">=A9 2003 SAS Institute Inc., =
Cary, NC,=20
USA. All rights reserved.</FONT></FONT> <FONT=20
face=3D"Arial, Helvetica, sans-serif"><BR><FONT color=3Dgray =
size=3D1><A=20
class=3Dcopyrightlink href=3D"http://www.sas.com/Copyright.html"=20
target=3D_blank>Terms of Use & Legal Information</A> | <A=20
class=3Dcopyrightlink href=3D"http://www.sas.com/Privacy.html"=20
target=3D_blank>Privacy Statement</A></FONT> </FONT></TD>
<TD width=3D60>
<DIV align=3Dright><A=20
onmouseover=3D"rOver('back2');window.status=3D'Display the =
previous page.';return true"=20
accessKey=3Db =
onmouseout=3D"rOut('back2');window.status=3D'';return true"=20
href=3D"javascript:%20prevPage()"><IMG height=3D19 alt=3Dback=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/back2.gif"=20
width=3D30 border=3D0 name=3Dback2></A><A=20
onmouseover=3D"rOver('next2');window.status=3D'Display the next =
page.';return true"=20
accessKey=3Dn =
onmouseout=3D"rOut('next2');window.status=3D'';return true"=20
href=3D"javascript:%20nextPage()"><IMG height=3D19 alt=3Dnext=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/next2.gif"=20
width=3D30 border=3D0 =
name=3Dnext2></A></DIV></TD></TR></TBODY></TABLE>
<P> </P>
<SCRIPT>writeLessonDiv()</SCRIPT>
<SCRIPT>writeHelpDiv()</SCRIPT>
<!-- #EndLibraryItem --><!-- InstanceEnd --></BODY></HTML>
------=_NextPart_000_0094_01C40507.AF1622F0
Content-Type: image/gif
Content-Transfer-Encoding: base64
Content-Location: http://www.sas.com/apps/elearning/images/en/navimages/bullet.gif
R0lGODlhCAAIAJEAAAAzmczMmQAAAAAAACwAAAAACAAIAAACDUSOYHjKvZh7U6qLsyoAOw==
------=_NextPart_000_0094_01C40507.AF1622F0
Content-Type: image/gif
Content-Transfer-Encoding: base64
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -