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
P2 P1 P2 P1 P1
to have the same newid (as in newid=6 in your sample) ?
Richard A. DeVenezia