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

st: RE: insheet command


From   [email protected]
To   [email protected]
Subject   st: RE: insheet command
Date   Fri, 23 Jul 2004 14:14:41 +0200

Keep the dot, save as CSV (with semicolon ";" as a separator), and then 
	insheet your_file.csv, delimiter(";")
(from memory, see help insheet)

--- Ben

-----Original Message-----
From: Armen Khachatryan [mailto:[email protected]] 
Sent: vrijdag 23 juli 2004 13:42
To: [email protected]
Subject: st: insheet command

Dear colleagues,

I am new to STATA, I apologize for asking simple questions.
The matter is that I try to bring in a relatively large dataset of some
6000 obs, and 20 variables from EXCEL.
I converted the file into csv, and read into STATA with INSHEET. 
STATA reads all as one single V1 with those many observations.

In my Excel file I have tried to change the European comma decimal
separator to be a dot. The result is the same. What should I do to get
my Excel file normally read by STATA?

Any help would be highly appreciated.

Armen

Armen Khachatryan
University of Hohenheim
Stuttgart, Germany
Tel:  0049 (0)711/459 26 00 or 33 03
Fax: 0049 (0)711/459 37 62 or 37 09




*
*   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/
*
*   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/



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