Something like this untested syntax may be what you need.

If you have one or more string variables, you could AUTORECODE them into a new set of variables

AUTORECODE VARIABLES= answer1 to answer7 /INTO x1 to x7 /GROUP /PRINT.

Then you could collapse some codes into a correctly spelled code. recode x1 to x7 (1,3,4,11=4) (73, 74, 75 =74) (200 thru 205= 202)(else=copy) into y1 to y7.

Autorecode variables= y1 to y7 /into z1 to z7 /group /print.

Art Kendall Social Research Consultants

Noble, Lyndsay wrote: > You know, I can't think of a more efficient way than recoding, but 600 > recodes seems daunting. Maybe someone else on the list serve has an idea? > > Lyndsay > > > -----Original Message----- > From: saygili ayca [mailto:aycasaygili@yahoo.com] > Sent: Wednesday, July 18, 2007 9:48 AM > To: Noble, Lyndsay > Subject: RE: recoding > > I appreciate if you know an efficient way: > > There is a variable that contains drug name. But in > CRF it is open ended question. There are a lot of > miscoding error. We are trying to clean data by > recoding. :)) > > --- "Noble, Lyndsay" <Lyndsay.Noble@ejgallo.com> > wrote: > > >> There might be a more efficient way of doing it than >> writing all of the >> recode statements. What is the nature of the >> situation? >> >> Lyndsay >> >> -----Original Message----- >> From: saygili ayca [mailto:aycasaygili@yahoo.com] >> Sent: Wednesday, July 18, 2007 1:20 AM >> To: Noble, Lyndsay >> Subject: RE: recoding >> >> thanx. we need around 600, that is why I asked. --- >> "Noble, Lyndsay" <Lyndsay.Noble@ejgallo.com> wrote: >> >> >>> Hi, >>> I've done up to around 70 and not had a problem. >>> >>> Lyndsay >>> -----Original Message----- >>> From: SPSSX(r) Discussion >>> [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of >>> saygili ayca >>> Sent: Tuesday, July 17, 2007 3:45 AM >>> To: SPSSX-L@LISTSERV.UGA.EDU >>> Subject: recoding >>> >>> Hi all, >>> >>> when we recode a variable into new variable, Is >>> there >>> any limitation on number of coding? >>> >>> Thanks >>> >>> >>> >>> >>> >>> > _____________________________________________________________________________ > >>> _______ >>> Building a website is a piece of cake. Yahoo! >>> >> Small >> >>> Business gives you all >>> the tools to get online. >>> http://smallbusiness.yahoo.com/webhosting >>> >>> >> >> >> >> > _____________________________________________________________________________ > >> _______ >> Be a better Globetrotter. Get better travel answers >> from someone who knows. >> Yahoo! Answers - Check it out. >> >> > http://answers.yahoo.com/dir/?link=list&sid=396545469 > > > > > > _____________________________________________________________________________ > _______ > Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for > today's economy) at Yahoo! Games. > http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow > > >