Date:         Thu, 20 Nov 2003 09:51:35 -0500
Reply-To:     Pat_Monk@US.CRAWCO.COM
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 problem...

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?

Pat Monk
Senior Network Systems Programmer
IT Technical Services
Office: 404 843-6203
Fax: 404 705-6817