--- In [email protected], Henrik Lindegaard <hli@s...> wrote:
> Dear listeners,
>
> I am trying to insheet a file containing rows of data of the
following
> format into Stata 9
>
> "Ringk=F8bing amt";"=D8RE-, N=C6SE- OG HALSAFDELING";"HOLSTEBRO
> CENTRALSYGEHUS";"Oto-, rhino-, laryngologi";8,3;9,7;8,2;6,8;6,6;4,8;
> "=C5rhus 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.
>
> Any suggestions would be welcome!
>
> Henrik
>
>
Common problem for european users. The easier way to avoid it: using
Excel, apply function "replace" comma by point (replace all) then
save as text file (tab delimited). open stata and import your .txt
file will work fine.
Hope this help..
Laurent
*
* 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/
