Date:         Thu, 18 Nov 2004 11:45:35 -0500
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: Assign a unique id

Khan, Muhammad Z. wrote:
> Dear SAS list;
>
>     I have been given a database with 5 columns.  The first column
> contains the provider id,  the 2nd, 3rd , 4th and 5th column also
> contains the provider id.  The goal is to create a new field  called
> newid  and assign a unique ID based on 2nd thru 5th columns.  The
> newid is the function of column 2nd thru 5th.  Please  see below
> for an example.  Any help from the list how to accomplish this will be
> appreciated.  I'm using SAS V8.
>

Describe what "the function of column 2nd thru 5th" is.

What function would cause

P1 P1 P1 P1 P1
and
P2 P1 P2 P1 P1

to have the same newid (as in newid=6 in your sample) ?




--
Richard A. DeVenezia
http://www.devenezia.com/