Date:         Fri, 12 Jan 2007 15:50:37 -0500
Reply-To:     Don Henderson <donaldjhenderson@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     RFC822 error: <W> MESSAGE-ID field duplicated. Last occurrence
              was retained.
From:         Don Henderson <donaldjhenderson@HOTMAIL.COM>
Subject:      Re: how to replace SSNs with fake
Comments: To: "Wainwright, Andrea" <andrea.wainwright@CAPITALONE.COM>
In-Reply-To:  <5849E9717D973D4680AD52C26826723E071D9EEB@KDCP4PMBX06.cof.ds.capitalone.com>
Content-Type: text/plain; charset="us-ascii"

In version 9 you can use the UUIDGEN (see
http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a002505764.htm)
function to assign a unique value.

And as Andrea suggests, you could then maintain a crosswalk table that maps
one value to the other using something like:

data mydata.crosswalk;
 set mydata.ssns(keep=ssn);
 newKey = uuidgen();
run;

HTH,
-don h

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Wainwright, Andrea
Sent: Friday, January 12, 2007 3:36 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: how to replace SSNs with fake

I would come up with a function to transform the given SSN to some other
number.  Then you can always reverse it to get back to the original, and if
you get new records you can apply the same function and get the same kinds
of keys.

Some consideration is needed for the function.  You don't want to divide and
round because that may map two different SSNs to the same ID.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Jen
Sent: Friday, January 12, 2007 12:39 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: how to replace SSNs with fake

Hello,

I have a file of information about people and I want to create an id
variable to replace SSN.  In this file people have multiple rows, ie, some
SSNs have multiple rows, others don't.

I know this probably a simple request but I couldn't find something similar
in a search.

Thanks,

Jen







The information contained in this e-mail is confidential and/or proprietary

to Capital One and/or its affiliates. The information transmitted herewith

is intended only for use by the individual or entity to which it is

addressed.  If the reader of this message is not the intended recipient,

you are hereby notified that any review, retransmission, dissemination,

distribution, copying or other use of, or taking of any action in reliance

upon this information is strictly prohibited. If you have received this

communication in error, please contact the sender and delete the material

from your computer.