Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: insheet, European format, comma

From   Ulrich Kohler <>
Subject   Re: st: insheet, European format, comma
Date   Mon, 29 Aug 2005 17:07:25 +0200

Henrik Lindegaard wrote:
> I am trying to insheet a file containing rows of data of the following
> format into Stata 9
> CENTRALSYGEHUS";"Oto-, rhino-, laryngologi";8,3;9,7;8,2;6,8;6,6;4,8;
> 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.


+49 (030) 25491-361

*   For searches and help try:

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