Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From   José Maria <jmpsouza@usp.br>
To   <statalist@hsphsun2.harvard.edu>
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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index