Command to recode multiple variables with a loop

[andrew roder]

Dear All,

How can I recode multiple variables using loop or any simple command and change it as follows:

if the value label is 1 or 2 recode it as 1 and if the value label is 3 recode it as 0 for all the variables from b3q1ss to b3q1cm


copy starting from the next line --------- ------ ------

* Example generated by -dataex-. For more info, type help dataex
clear
input byte(b3q1ss b3q1bh b3q1mb b3q1ht b3q1rc b3q1fc b3q1fn b3q1cc    b3q1ov    b3q1cp    b3q1rg    b3q1wm    b3q1mp    b3q1ms    b3q1sw    b3q1ch    b3q1wb    b3q1tv    b3q1cm)
3 2 3 3 3 3 3 3 3 3 3 3 3 2 3 2 3 3 3
3 2 3 3 3 2 3 3 3 3 3 3 3 2 2 2 3 3 3
3 2 2 3 3 3 3 3 3 3 3 3 3 3 3 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 2 3 2 3 3 3
3 2 1 3 3 3 3 3 1 3 3 3 2 3 2 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 2 3 3 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 2
3 2 3 3 3 3 3 3 3 3 3 3 1 3 3 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 2 3 1 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 2 3 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 2 3 1 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 1 3 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 2 3 3 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 3 3 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 2 3 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 2 3 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 3 3 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 1 2 2 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 1 2 3 3 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 1 2 3 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 1 2 2 2 3 3 3
2 2 3 3 3 3 3 3 3 3 3 3 2 3 3 2 3 3 2
3 2 3 3 3 3 3 3 3 3 3 3 1 2 3 2 3 3 3
3 1 3 3 3 3 3 3 3 3 3 3 1 3 3 3 3 3 3
3 1 3 3 3 3 3 3 3 3 3 3 1 2 3 2 3 3 3
3 3 3 3 3 3 3 3 3 3 3 3 2 3 3 3 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 2 3 3 3 3 3
3 2 3 3 2 2 3 2 3 3 2 3 1 2 3 3 2 2 3
2 2 2 3 2 3 3 2 3 3 2 3 1 2 3 2 2 2 3
2 1 3 2 2 2 3 2 3 3 2 3 3 3 3 2 2 2 3
2 2 3 1 2 3 3 2 3 3 3 3 2 1 2 3 2 2 3
3 2 3 3 2 3 3 2 3 3 2 3 3 2 3 2 2 3 2
3 2 3 3 3 3 3 2 3 3 3 3 3 1 3 2 1 3 3
1 2 3 2 2 3 3 3 3 3 1 3 1 2 3 3 2 2 3
2 2 3 3 2 3 3 2 3 3 2 3 1 2 3 2 2 2 3
3 2 3 3 2 3 3 2 3 3 3 3 1 2 3 2 2 2 3
3 1 3 3 1 3 3 3 3 3 3 3 1 2 3 1 1 3 3
3 2 3 3 2 2 3 3 3 3 2 3 2 3 3 3 3 3 3
3 2 3 3 2 3 3 1 3 3 3 3 3 1 3 2 2 3 3
2 2 3 3 2 2 3 2 3 3 2 2 2 3 2 2 2 2 3
3 2 3 3 2 3 3 3 3 3 3 3 1 2 3 2 3 2 3
3 2 2 3 2 3 3 2 3 3 3 3 1 3 2 2 2 2 3
3 2 3 3 3 3 3 3 3 3 3 3 3 3 2 2 3 3 3
3 2 3 3 2 3 3 2 3 3 3 3 3 2 3 2 3 3 3
3 2 3 3 2 3 3 3 3 3 3 3 1 2 3 3 2 3 3
3 3 3 2 2 3 3 3 3 3 3 3 1 3 3 2 2 1 1
3 1 3 3 2 3 3 2 3 3 3 3 3 2 3 2 2 3 3
3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
3 2 3 3 2 3 3 1 3 3 3 3 3 3 2 2 3 3 3
3 2 3 3 2 3 3 2 3 3 3 3 1 2 3 2 2 2 2
3 2 3 3 2 3 3 3 3 3 3 3 3 2 3 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 1 2 2 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 3 3 2 3 3 3
2 2 3 3 2 2 3 2 3 2 2 2 1 2 3 1 2 2 2
3 2 3 3 3 3 3 3 3 3 3 3 1 3 3 2 3 3 3
3 2 2 3 2 3 3 3 3 3 3 3 1 3 3 2 2 3 3
3 2 3 2 2 2 3 2 3 3 2 2 2 3 3 2 2 3 3
2 2 3 2 2 3 3 3 3 3 3 3 1 2 2 2 3 2 3
3 1 3 3 2 3 3 2 3 3 3 3 3 2 3 3 3 3 3
2 2 3 2 2 2 3 2 3 3 2 2 1 2 2 2 2 2 2
3 2 3 3 2 3 3 3 3 3 3 3 3 2 3 2 2 3 3
2 2 3 2 2 3 3 2 3 3 3 3 1 2 3 2 2 2 3
3 3 3 1 2 3 3 3 3 3 3 3 1 3 3 3 3 3 3
2 2 2 3 2 3 3 2 3 3 3 3 2 3 3 2 2 2 2
3 2 3 3 2 3 3 3 3 3 3 3 3 2 3 2 2 2 3
3 2 3 3 2 3 2 2 3 3 3 3 1 2 3 2 2 2 3
3 2 3 3 2 3 3 2 3 3 3 3 3 2 2 2 3 3 3
3 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
3 2 3 3 2 3 3 2 3 3 3 3 3 3 3 2 2 3 3
1 2 2 3 2 3 3 2 3 3 3 3 3 2 2 2 2 2 3
3 2 3 3 2 3 3 3 3 3 3 3 3 3 3 2 3 3 3
3 1 3 3 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3
3 2 3 3 2 3 3 2 3 3 3 3 3 3 3 2 3 3 3
3 2 3 3 2 3 3 2 3 3 3 3 3 2 3 2 2 3 3
3 2 3 3 2 3 3 3 3 3 3 3 3 2 3 3 3 3 3
3 2 3 3 2 3 3 2 3 3 3 3 3 2 3 2 2 3 3
3 3 3 3 2 3 3 3 3 3 3 3 3 3 3 3 2 3 3
3 2 2 2 2 3 3 2 3 3 3 3 3 2 3 2 2 1 3
3 3 3 3 1 3 3 1 3 3 3 3 3 3 3 3 1 3 3
3 2 3 3 2 3 3 2 3 3 3 3 3 3 3 2 2 1 3
3 3 3 2 2 2 3 2 3 3 2 2 3 2 3 2 2 2 2
3 2 3 3 2 3 3 2 3 3 3 3 3 3 3 2 1 2 3
3 2 3 3 2 3 3 2 3 3 3 3 3 2 2 2 3 3 3
2 2 3 3 2 2 3 2 3 3 3 3 3 2 3 2 2 1 3
2 2 3 3 2 3 3 2 3 3 3 3 3 2 3 2 3 3 3
2 2 3 2 2 2 2 2 3 3 3 2 3 3 2 2 2 2 3
3 3 3 3 2 3 3 2 3 3 3 3 3 3 3 3 2 3 3
3 2 3 3 2 3 3 2 3 3 3 3 2 3 3 3 2 3 3
3 3 3 2 2 3 3 3 3 3 3 3 3 3 3 3 3 2 3
2 2 3 3 2 3 3 2 3 3 3 3 3 3 3 2 3 2 3
3 1 3 3 2 3 3 2 3 3 3 3 3 2 3 2 3 3 3
3 2 3 3 2 3 3 2 3 3 3 3 3 2 3 2 2 3 3
3 2 3 3 2 2 3 2 3 3 3 3 3 2 3 2 2 2 3
2 2 2 3 2 3 3 2 3 3 3 3 3 2 3 1 2 2 3
1 2 2 3 2 3 3 2 3 3 3 3 3 2 3 2 2 2 3
3 2 3 3 2 3 3 3 3 3 3 3 3 3 3 2 3 3 3
end
label values b3q1ss b3q1ss
label def b3q1ss 1 "Yes acquired less than a year", modify
label def b3q1ss 2 "Yes acquired a year or more ago", modify
label def b3q1ss 3 "No", modify
label values b3q1bh b3q1bh
label def b3q1bh 1 "Yes acquired less than a year", modify
label def b3q1bh 2 "Yes acquired a year or more ago", modify
label def b3q1bh 3 "No", modify
label values b3q1mb b3q1mb
label def b3q1mb 1 "Yes acquired less than a year", modify
label def b3q1mb 2 "Yes acquired a year or more ago", modify
label def b3q1mb 3 "No", modify
label values b3q1ht b3q1ht
label def b3q1ht 1 "Yes acquired less than a year", modify
label def b3q1ht 2 "Yes acquired a year or more ago", modify
label def b3q1ht 3 "No", modify
label values b3q1rc b3q1rc
label def b3q1rc 1 "Yes acquired less than a year", modify
label def b3q1rc 2 "Yes acquired a year or more ago", modify
label def b3q1rc 3 "No", modify
label values b3q1fc b3q1fc
label def b3q1fc 2 "Yes acquired a year or more ago", modify
label def b3q1fc 3 "No", modify
label values b3q1fn b3q1fn
label def b3q1fn 2 "Yes acquired a year or more ago", modify
label def b3q1fn 3 "No", modify
label values b3q1cc b3q1cc
label def b3q1cc 1 "Yes acquired less than a year", modify
label def b3q1cc 2 "Yes acquired a year or more ago", modify
label def b3q1cc 3 "No", modify
label values b3q1ov b3q1ov
label def b3q1ov 1 "Yes acquired less than a year", modify
label def b3q1ov 3 "No", modify
label values b3q1cp b3q1cp
label def b3q1cp 2 "Yes acquired a year or more ago", modify
label def b3q1cp 3 "No", modify
label values b3q1rg b3q1rg
label def b3q1rg 1 "Yes acquired less than a year", modify
label def b3q1rg 2 "Yes acquired a year or more ago", modify
label def b3q1rg 3 "No", modify
label values b3q1wm b3q1wm
label def b3q1wm 2 "Yes acquired a year or more ago", modify
label def b3q1wm 3 "No", modify
label values b3q1mp b3q1mp
label def b3q1mp 1 "Yes acquired less than a year", modify
label def b3q1mp 2 "Yes acquired a year or more ago", modify
label def b3q1mp 3 "No", modify
label values b3q1ms b3q1ms
label def b3q1ms 1 "Yes acquired less than a year", modify
label def b3q1ms 2 "Yes acquired a year or more ago", modify
label def b3q1ms 3 "No", modify
label values b3q1sw b3q1sw
label def b3q1sw 2 "Yes acquired a year or more ago", modify
label def b3q1sw 3 "No", modify
label values b3q1ch b3q1ch
label def b3q1ch 1 "Yes acquired less than a year", modify
label def b3q1ch 2 "Yes acquired a year or more ago", modify
label def b3q1ch 3 "No", modify
label values b3q1wb b3q1wb
label def b3q1wb 1 "Yes acquired less than a year", modify
label def b3q1wb 2 "Yes acquired a year or more ago", modify
label def b3q1wb 3 "No", modify
label values b3q1tv b3q1tv
label def b3q1tv 1 "Yes acquired less than a year", modify
label def b3q1tv 2 "Yes acquired a year or more ago", modify
label def b3q1tv 3 "No", modify
label values b3q1cm b3q1cm
label def b3q1cm 1 "Yes acquired less than a year", modify
label def b3q1cm 2 "Yes acquired a year or more ago", modify
label def b3q1cm 3 "No", modify

copy up to and including the previous line ---- ------ ------

Listed 100 out of 9798 observations

.
Thank you

[Clyde Schechter]

recode b3q1ss-b3q1cm (1/2 = 1) (3 = 0)

Added: You may want to also change the value labels on these variables to a simple Yes/No. For that

label define boolean    0    "No"    1    "Yes"
label values b3q1ss-b3q1cm boolean