<>
Try this with your data, but make backups to guard against any nasty
surprises along the way. The auto dataset has only one string, so this
example looks stupid - but isn`t...
*************
sysuse auto, clear
qui ds, has(type string)
foreach var of varlist `r(varlist)'{
encode `var', gen(`var'new)
drop `var'
rename `var'new `var'
}
**************
HTH
Martin
_______________________
----- Original Message -----
From: "Arina Viseth" <[email protected]>
To: <[email protected]>
Sent: Thursday, February 12, 2009 9:17 PM
Subject: st: encode question
Dear all,
I have a dataset that I imported from Excel using insheet. However, many
numerical variables (I have about 200 variables) are now showed as string
variables.
My question is the following: how can I transform each string variable
into numerical one - and also replicate their names - without having to
encode manually each one of them?
Thank you very much in advance for any help, I would very much appreciate
it.
Arina
*
* 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/
*
* 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/
