Date:         Mon, 8 Apr 2002 12:18:53 -0400
Reply-To:     "Burnkrant, Steve R." <SRBURNKR@opm.gov>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Burnkrant, Steve R." <SRBURNKR@opm.gov>
Subject:      Re: Macros to recode data

You could just use the replace function. Better yet, why not recode in SPSS?
That said, this will reverse code a two point scale.

Sub RecodeStuff()
  Columns("A:O").Select
  Selection.Replace What:="1", Replacement:="2temp", LookAt:=xlwhole
  Selection.Replace What:="2", Replacement:="1temp", LookAt:=xlwhole
  Selection.Replace What:="2temp", Replacement:="2", LookAt:=xlwhole
  Selection.Replace What:="1temp", Replacement:="1", LookAt:=xlwhole
End Sub

--Steve
-----Original Message-----
From: Jennifer Doyle [mailto:jdoyle@caregroup.harvard.edu]
Sent: Monday, April 08, 2002 11:21 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Macros to recode data


 I am sorry to bother everyone with what is undoubtedly an elementary
problem, but I've never used macros before, and I need to recode data in
excel before importing the data to SPSS.  Would someone be so kind as to
tell me how to recode in an EXCEL macro? I have 16 variables and about 1,000
cases.  ANY assistance would be greatly appreciated -- many thanks, Jennifer


Jennifer Doyle, M.A.
Lecturer on Surgery, Harvard Medical School;
Director of Educational Development & Evaluation
Departments of Graduate Medical Education and Surgery
Beth Israel Deaconess Medical Center
110 Francis Street - Suite 3A
Boston, MA  02215 - 5501
phone: 617-632-8632   OR  617-432-3078 (HMS office)
Fax:    617-632-7424

e-mail:  jdoyle@caregroup.harvard.edu  or
<mailto:jennifer_doyle@hms.harvard.edu>




-------------------------------
--  Even though this E-Mail has been scanned and found clean of
--  known viruses, OPM can not guarantee this message is virus free.
-------------------------------
--  This message was automatically generated.
-------------------------------