LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 2011, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 4 May 2011 16:46:07 +0000
Reply-To:   toby dunn <tobydunn@HOTMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   toby dunn <tobydunn@HOTMAIL.COM>
Subject:   Re: column recoding
Comments:   To: snoopy369@gmail.com
In-Reply-To:   <BANLkTi=qsR=Oycx+T61+NiwC_uY8Y5W56A@mail.gmail.com>
Content-Type:   text/plain; charset="iso-8859-1"

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 > > > >


Back to: Top of message | Previous page | Main SAS-L page