Hi Mina,
Just wondering if AUTORECODE would help? or alternatively, you could use CHAR.SUBSTR to split the postcodes into multiple, shorter strings, and recode these?
Roger
------------------------------
Roger Fiedler
------------------------------
Original Message:
Sent: Wed July 24, 2024 08:01 PM
From: Amina Gh
Subject: Recoding a variable with multiple values
Hi,
I need some help to recode a string variable with multiple values.
I have a postcode variable where respondents entered their postcodes as text. Some postcodes are repeated, while others are identical but written differently. The list of postcode responses is extensive, and I want to group them into 5 categories. How can I recode these multiple postcode values into 5 distinct categories?
Any help would be greatly appreciated.
Best,
Mina
------------------------------
Mina
------------------------------
#AIandDSSkills