Hello there, Among other variables, I have a data set with 6 character variables (lenght 4) like this:
Obs
Var1
Var2
Var3
Var4
Var5
Var6
1
O809
O809
Z370
Z301
Z390
A20X
2
B171
B172
K746
I10X
I519
K546
3
O809
O809
Z370
Z302
Z390
4
X101
X102
I12X
and would like:
1.- to get rid of the "X" but only for entries with the "X" at the end so de data would look like:
Obs
Var1
Var2
Var3
Var4
Var5
Var6
1
O809
O809
Z370
Z301
Z390
A20
2
B171
B172
K746
I10
I519
K546
3
O809
O809
Z370
Z302
Z390
4
X101
X102
I12
then
2.- I would like to create new variables that are within a specific range, for example if I want a new variable Z to select any entry of Var1 to Var 6 between Z301 and Z370, the new variable would be like the example below, in this case "VariableZ", if I want another new varible to select any value of Var1 to Var6 to be between B171 and B172 or between X101 and X102 the new variables would be respectivelly like "VariableB" and "VariableX" below and so on
New data set
Obs
Var1
Var2
Var3
Var4
Var5
Var6
VariableZ
VariableB
VariableX
1
O809
O809
Z370
Z301
Z390
A20
Z301-Z370
2
B171
B172
K746
I10
I519
K546
B171-172
3
O809
O829
Z370
Z302
Z390
Z301-Z370
4
X101
D109
I12
X101-X102
all your help will be appreciated
Thanks
EHG.
... View more