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" <[email protected]>
To: <[email protected]>
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/
