Okay, another newbie question...

I have a dataset that includes hundreds of thousands of police stops.  For each, if the stop was based on a possible violation of the law, the code section violated had to be included in the stop data ("Suspicion_offense_CD").  I have a list of all of the hundreds, if not thousands, of possible codes.  I would like to recode the code section violated into a new variable that just indicates whether the violation was an "infraction" "misdemeanor" or "felony," and I already have an excel spreadsheet that includes each code and denotes whether it is infraction, misdemeanor or felony.  Is there a way to recode into a new variable without entering each of those values?  What is the quickest/easiest way to recode these into new variables? (Ideally 0/1/2/3 for "none/infraction/misdemeanor/felony")

Thank you

------------------------------
Melanie Ochoa
------------------------------

#SPSSStatistics

Original Message:
Sent: 5/13/2022 7:02:00 PM
From: Melanie Ochoa
Subject: Can you recode from excel or other file?

Okay, another newbie question...

I have a dataset that includes hundreds of thousands of police stops.  For each, if the stop was based on a possible violation of the law, the code section violated had to be included in the stop data ("Suspicion_offense_CD").  I have a list of all of the hundreds, if not thousands, of possible codes.  I would like to recode the code section violated into a new variable that just indicates whether the violation was an "infraction" "misdemeanor" or "felony," and I already have an excel spreadsheet that includes each code and denotes whether it is infraction, misdemeanor or felony.  Is there a way to recode into a new variable without entering each of those values?  What is the quickest/easiest way to recode these into new variables? (Ideally 0/1/2/3 for "none/infraction/misdemeanor/felony")

Thank you

------------------------------
Melanie Ochoa
------------------------------

#SPSSStatistics