Joe, Im thinking pretty much along the same lines as you, simple easy peise problem to solve.

Toby Dunn

"I'm a hell bent 100% Texan til I die"

"Don't touch my Willie, I don't know you that well"

> Date: Wed, 4 May 2011 11:43:29 -0500 > From: snoopy369@GMAIL.COM > Subject: Re: column recoding > To: SAS-L@LISTSERV.UGA.EDU > > So essentially you could simply take all three columns, output them in a > single column, use one of the various methods available to get unique values > (proc freq, sort nodupkey, etc.), and then process that in a data step > assigning _n_ as the value for each original value; then use a proc format > to apply those values. > > No? > > -Joe > > On Wed, May 4, 2011 at 11:40 AM, oslo <hokut1@yahoo.com> wrote: > > > Nat; > > > > Thanks for writing. No there is no rule. I just gave an examle. Only rule > > is > > that there are same value in all 3 columns and they are repeating many > > time. > > These should be assigned with same value. > > > > regards, > > > > Oslo > > > > > > > > > > ________________________________ > > From: Nat Wooding <nathani@VERIZON.NET> > > To: SAS-L@LISTSERV.UGA.EDU > > Sent: Wed, May 4, 2011 11:31:55 AM > > Subject: Re: column recoding > > > > Oslo > > > > Is there some set of rules that determine why IG should be 5 and 14 should > > be 6? > > > > Nat Wooding > > > > -----Original Message----- > > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of oslo > > Sent: Wednesday, May 04, 2011 11:55 AM > > To: SAS-L@LISTSERV.UGA.EDU > > Subject: column recoding > > > > Dear all; > > > > I have very big and messy data set. I need to reorganize it via SAS for > > analyses > > the different software (ASREML....). I need to recode the first 3 columns > > of > > > > data which they are for pedigree part. Each column contains both numeric > > and > > > > non-numeric info. I want to convert all of them into numeric. Suppose the > > first > > columns of data is in the following pattern, > > > > Your helps are greatly appreciated. Regards, > > > > Oslo > > > > data I have data I want to have > > id sire dam id sire dam > > a4 ch a&M 1 2 3 > > 9 IG 14 4 5 6 > > R/h cm R/h 7 8 7 > > . . . . . . > > and so on > > > >