Henrik Lindegaard wrote:
> I am trying to insheet a file containing rows of data of the following
> format into Stata 9
>
> "Ringkøbing amt";"ØRE-, NÆSE- OG HALSAFDELING";"HOLSTEBRO
> CENTRALSYGEHUS";"Oto-, rhino-, laryngologi";8,3;9,7;8,2;6,8;6,6;4,8;
> "Århus amt";"KARDIOLOGISK AFDELING B";"SKEJBY
> SYGEHUS";"Kardiologi";2,7;8,8;5,7;5,7;7,7;13,4;
>
> by using
>
> insheet using "path", delimiter(";") names clear
>
> but unfortunately the data in columns 5 to 10 are imported as strings
> (probably due to the European format), and I cannot figure out how to
> change this.
If the data stems from Excel you might change the language settings in Excel
and export the file again. If this is not an option I would do that within
Stata as follows:
. foreach var of varlist var5-var10 {
. replace `var' = subinstr(`var',",",".",.)
. destring `var', gen(`var'n)
. drop tempvar
. }
Explanation: Inside the loop, the first command replaces the "commas" with
"dot", the second generates "real" variables from the changed versions.
See -help strfun- and -help destring- for details.
Uli
--
[email protected]
+49 (030) 25491-361
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
