# st: Re: re: generating a new numerical variable3 using a string variable2 which is nested in a numerical variable1

 From José Maria To Subject st: Re: re: generating a new numerical variable3 using a string variable2 which is nested in a numerical variable1 Date Sat, 14 Nov 2009 14:20:55 -0200

```Thank you, Kit.
I will try.
José Maria
Jose Maria Pacheco de Souza, Professor Titular (aposentado)
Departamento de Epidemiologia/Faculdade de Saude Publica, USP
Av. Dr. Arnaldo, 715
01246-904  -  S. Paulo/SP - Brasil
fones (11)3061-7747; (11)3768-8612;(11)3714-2403
www.fsp.usp.br/~jmpsouza
```
----- Original Message ----- From: "Kit Baum" <baum@bc.edu>
```To: <statalist@hsphsun2.harvard.edu>
Sent: Saturday, November 14, 2009 1:57 PM
```
Subject: st: re: generating a new numerical variable3 using a string variable2 which is nested in a numerical variable1
```

```
```<>
```
Assumes string variable is lowercase. Easy to modify that with lower(), upper(), etc.
```
clear
input var1 str1 var2
1 a
1 a
1 a
1 b
2 m
2 m
2 n
2 n
2 n
2 p
3 c
3 c
3 c
3 c
end
local alpha = subinstr("`c(alpha)'", " ", "", .)
g av2 = strpos("`alpha'", var2)
egen t = tag(var1 av2)
egen av3 = rank(av2) if t, by(var1)
bys var1 av2: egen av4 = mean(av3)
l

```
Kit Baum | Boston College Economics & DIW Berlin | http://ideas.repec.org/e/pba1.html An Introduction to Stata Programming | http://www.stata-press.com/books/isp.html An Introduction to Modern Econometrics Using Stata | http://www.stata-press.com/books/imeus.html
```

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

```
__________ Informação do ESET NOD32 Antivirus, versão da vacina 4607 (20091114) __________
```
A mensagem foi verificada pelo  ESET NOD32 Antivirus.

http://www.eset.com

```
```

__________ Informação do ESET NOD32 Antivirus, versão da vacina 4607 (20091114) __________

A mensagem foi verificada pelo  ESET NOD32 Antivirus.

http://www.eset.com

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```