Date: Thu, 20 Nov 2003 09:51:35 -0500
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Pat Monk <Pat_Monk@US.CRAWCO.COM>
Subject: How To Match/Merge Multiple Observations to Multiple Observations.
Content-Type: text/plain; charset="us-ascii"
I have a SAS database containing 4MM+ observations built from SMF type6
records. I have a second "control" database that I need to "match" to the
first database on a variable named LUNAME.
The control database contains observations that identify the remote
printer id (Rnnnn) for a given LUNAME as of a certain date range. Now for
The control database may contain multiple observations for a given LUNAME,
based upon a START DATE-END DATE range identified in the control record.
In other words, for a given LUNAME found in an SMF type6 record, the
associated Rnnnn is to be determined by the date within the type6 SMF
record falling in a given date range in a matching control record.
I have not found a technique that will successfully match the SMF records
to the appropriate control record in order to determine the correct Rnnnn
for any given date.
Can you suggest a solution to my multiple-to-multiple match problem?
Senior Network Systems Programmer
IT Technical Services
Office: 404 843-6203
Fax: 404 705-6817