Date:         Tue, 17 Mar 2009 16:16:01 -0400
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: Delete Duplicated Records based on multiple columes,  Thanks!
Comments: To: Nancy <nancy0318@GMAIL.COM>
In-Reply-To:  <94a7b954-a072-4c93-86d6-190d53e2ae8d@c36g2000yqn.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

Nancy:
Relational database design and "normalization" has as one objective a reduction of bothersome redundancies in databases. If you wish to retain multiple or historic addresses without repeating names and other personal attributes, partition personal attributes out into a table with a key value that represents a person (PID) and use that key and an address sequence number or key to link a person to multiple addresses. You can then link persons to addresses using the keys. Any other method of handling multiple addresses for each person will increase the risk of mistakes and the difficulty of programming.
S

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Nancy
Sent: Tuesday, March 17, 2009 2:50 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Delete Duplicated Records based on multiple columes, Thanks!


I want to delete Duplicated records based on same ( last name, first name, birthday, collected day, result, lab, lab number ) .At same time I want to keep as much as more inforamtion for the other columes such as  address, city and state.

Can anyone give me some  hint about how to make this efficiency?

Thank you so much!

Nancy