Date: Tue, 15 Jan 2002 18:20:07 -0500
Reply-To: Doc Muhlbaier <lawrence.muhlbaier@DUKE.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Doc Muhlbaier <lawrence.muhlbaier@DUKE.EDU>
Organization: Duke University, Durham, NC, USA
Subject: Re: a question on merge
Content-Type: multipart/alternative;
This is a multi-part message in MIME format.
------=_NextPart_000_001D_01C19DF1.42ECD120
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
read the discussion of the "many-to-one transformation" that appear on =
this list earlier this morning; you are asking the same question.
Doc
"Zhonghe Li" <zli@HSPH.HARVARD.EDU> wrote in message =
news:063901c19e16$4ef87760$23c0a8c0@ICARUS...
Sorry I didn't make the question clear last time.
I have two files (Personal Summary: PS94 and PS95). They contain same =
variables (same variable name) for two different years. Now I need to =
merge them into one file by person ID, but at the time I need all the =
two year variables in the file.
year94 year95
ID X1 X2 X3 X4.... ID X1 X2 X3 X4....
I need
ID X1 X2 X3 X4....X1_95 X2_95 X3_95 X4_95...
Is there an easy way to do so without renaming the variables (a lot =
variables to rename)?
Thank you for your help.
Zhonghe
------=_NextPart_000_001D_01C19DF1.42ECD120
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>read the discussion of the "many-to-one =
transformation" that appear on this list earlier this morning; you are =
asking=20
the same question.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Doc</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Zhonghe Li" <<A=20
href=3D"mailto:zli@HSPH.HARVARD.EDU">zli@HSPH.HARVARD.EDU</A>> =
wrote in=20
message <A=20
=
href=3D"news:063901c19e16$4ef87760$23c0a8c0@ICARUS">news:063901c19e16$4ef=
87760$23c0a8c0@ICARUS</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Sorry I didn't make the question =
clear last=20
time.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV> </DIV>
<DIV>I have two files (Personal Summary: PS94 and PS95). They =
contain=20
same variables (same variable name) for two different years. Now =
I need=20
to merge them into one file by person ID, but at the time I =
need all the=20
two year variables in the file.</DIV>
<DIV> </DIV>
<DIV>year94 =20
=
=20
=
=20
year95</DIV>
<DIV>ID X1 X2 X3 X4.... =20
=
ID=20
X1 X2 X3 X4....</DIV>
<DIV> </DIV>
<DIV>I need</DIV>
<DIV> </DIV>
<DIV>ID X1 X2 X3 X4....X1_95 X2_95 X3_95 X4_95...</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Is there an easy way to do so without renaming the variables (a =
lot=20
variables to rename)?</DIV>
<DIV> </DIV>
<DIV>Thank you for your help.</DIV>
<DIV> </DIV>
<DIV>Zhonghe</DIV></FONT></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_001D_01C19DF1.42ECD120--
